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 |
|
Frozen_123
Starting Member
33 Posts |
 Posted - 2008-06-12 : 09:24:15
|
| Hi All,I want to generate script for users and their associated permissions on the xyz database and at the same time I want to generate script for associated logins and their roles over the xyz database.I am using SQL 2005 environment.Needs urgent help.Regards,Austin |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-06-12 : 09:39:56
|
| sp_helprolemember |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-12 : 11:07:40
|
| sp_helplogins and sp_helpuser for database. |
|
|
|
|
|
|
Logins