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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2010-02-19 : 07:56:28
|
| Hii've two logins in my instance, and i need script to generate all the database roles of these two logins.i think there are several system views to do this, but not sure.any help....advance thanksArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
vaibhavktiwari83
Aged Yak Warrior
843 Posts |
Posted - 2010-02-19 : 08:16:11
|
| exactly what you want please explainbecause its easy to generate scrip that i suppose you know...Vabhav T |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-02-19 : 08:26:38
|
| i've two Logins A nad B, i need the script for the database level roles of these two users.sp_helprevlogin gives the details of all the users with passwords, but i need database roles of these two users.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2010-02-19 : 09:15:48
|
| no help????ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
script to generate database roles of logins