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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Security Audit Report Format

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

Jarthda
Embarcadero/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.
Go to Top of Page
   

- Advertisement -