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 |
|
cshekar
Starting Member
49 Posts |
 Posted - 2004-12-22 : 11:51:34
|
| Hi I want to list all the users or logins with theire access levellike I have 20 databases in one production server I can get users and select * from sysusers table all logins from sysloginsbut I need security access level like who got update,insert or delete access in all database so please help me with this how can I list all security acces levelsThankschchandra shekar |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-22 : 13:31:20
|
| select sp_helpuserfrom BooksOnlineHTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
 |
|
|
cshekar
Starting Member
49 Posts |
Posted - 2004-12-22 : 13:35:30
|
| Thank you for your replybut that sp_helpuser will give me the list of users I wanted knownall users what access level tehy have liek update delete, insert to table etc??Thankschchandra shekar |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-22 : 17:56:56
|
| sp_helprotectI'll bet that if your life depended on it, you could have found this in BOL.HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
|
|
|
|
|
|
List all users/ Logins acces level