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 |
|
jarthda
Starting Member
10 Posts |
 Posted - 2013-02-05 : 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 JarthdaEmbarcadero/SQL Server/and now... Informatica |
|
|
srimami
Posting Yak Master
160 Posts |
Posted - 2013-02-05 : 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