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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2007-05-15 : 10:43:44
|
| GurusLike we use sp_helprotect to get the list of users who have got different permissions on the tables,How can we get something like that on the Database Level?Like All the users who has access and what level of access.Regards |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-15 : 13:15:36
|
| Try with sp_helplogins. |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2007-05-16 : 04:18:36
|
| HiThanks for the Reply.With sp_helplogins i wiont get the permissions and everything..Plz helpregards |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-16 : 13:21:05
|
| It tells which db roles the user is member of. Any specific you need? |
|
|
|
|
|
|
Rights On the DB