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 |
|
ObaidKhan
Starting Member
1 Post |
 Posted - 2005-05-05 : 20:06:33
|
HiHow do we see all the users with their permissions? Do we have a stored proc in place that I can use or if not, has anyone writen any code that will script out all the users with their respective permissions. Thanks for your help in Advance. |
|
|
RMK
Starting Member
2 Posts |
Posted - 2005-05-06 : 00:37:05
|
| u can use sp_helplogin to get login namealso use sp_ helpuser on database to get user and permission details on each db |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-06 : 07:32:41
|
i think i posted a script for this, i'm too lazy to repost  --------------------keeping it simple... |
|
|
|
|
|
|
Logins & their permissions