|
jarthda
Starting Member
8 Posts |
 Posted - 02/05/2013 : 16:29:59
|
Anyone have a link, or can otherwise suggest, a digestable format for login and db user security/audit report? I need to show login to db user mapping, then at the next level object privilages for each DBuser. Scripts welcome
Jarthda
Embarcadero/SQL Server/and now... Informatica |
|
|
srimami
Posting Yak Master
152 Posts |
Posted - 02/05/2013 : 22:31:12
|
In Object Explorer, right click on Security - Logins - Create new login and enter the details. Before you click ok, select scripts on top left corner and close the window. Go to logins, right click and assign related permissions under mappings; select scripts and close the window.
You can execute these scripts one by one. |
 |
|
Security Audit Report Format
