Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Swarna Dev
Starting Member
2 Posts |
 Posted - 2005-09-02 : 02:27:40
|
| Hi All,I'm new to SQL Server and I need to check the permissions of all the users on a said SQL Server. How do I do that? Is there any command or script that I can run and get the desired information?Kindly help asap.Thanks in advance.Regards,Swarna Dev |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-02 : 08:48:55
|
| for tables permissions you can do...USE DB1SELECT * FROM INFORMATION_SCHEMA.TABLE_PRIVILEGESUSE DB2etc...or you might want to look at sp_helprotect...or you can write your own query that queries the system tables but this may not port to the next version of sql server. You are going to want to start with syspermissions.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
Swarna Dev
Starting Member
2 Posts |
Posted - 2005-09-06 : 03:56:42
|
| Hi Sean,Thanks a lot. It works fine.Though I am looking for all the permissions given to a user and not just table permissions but... this will do for the moment. Please keep me posted if there is anything else. Thanks. Regards,Swarna |
|
|
|
|
|
|
View User Permissions