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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2007-10-09 : 08:44:19
|
| Hello All,Following information is requested by the audit company. Can anyone tell me how to script the roles from all the databases on the prodcutino server which would give me the following information. Role: temp_emp Members: name1, name2, name3, etc... Access: DB1 (read/write), DB2 (read/write), SP1 (execute), etc... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-09 : 23:13:13
|
| You have to write your own script for that. |
 |
|
|
|
|
|
Script the database roles