Re: Output Security Settings From DB

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/11/05 

Date: Thu, 10 Nov 2005 23:01:10 -0500

Have a look here:

http://www.sql-server-performance.com/bm_object_permission_scripts.asp

http://www.sql-server-performance.com/rd_auditing2.asp 

-- 
Andrew J. Kelly  SQL MVP
"Eddie H" <EddieH@discussions.microsoft.com> wrote in message 
news:EECA55FC-3AE2-4D74-BEF5-77CAF9A72E6D@microsoft.com...
>I am going through an audit and need some way to display the users that 
>have
> permissions on each database on a server.  This would be a very manual
> process unless I could find some way to pull this out of the system tables
> with a query.  Has anyone ever come across a program or script to 
> accomplish
> this?  Any insight would be appreciated.
> thanks.

Relevant Pages