Extracting NT User Group privs to dbs

I have been asked to provide the following info. for all our sql server
databases (of which there are many)
For the servers running Windows/Mixed security:
-Which NT groups are granted permissions to which databases
-What permissions are the NT groups granted to which databases
I know that this is possible to obtain through the gui, by running
Enterprise Manager and looking at Security > Logins > Database Access, but i
t
must also be stored in the data dictionary somewhere.
Would you know which views contain this information?
Effectively, how do I get a comprehensive report on NT Group access to SQL
Server dbs?
We have a mix of dbs from 6.5 up to 2000. Our platforms are across NT to
WIN 2003.SD,
you can create some complex script to script out all of the permissions
but you could also try a tool called SQL Dump Permisions. It's free and
does mainly what you need. Check
http://www.sqlservercentral.com/col...permissions.asp
for the download. You might need to register on SQLServercentral
though.
Markus|||Hi,
you may find it from system databas table , or may find a script from
www.sql-server-performance.com/forum
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"SD" wrote:

> I have been asked to provide the following info. for all our sql server
> databases (of which there are many)
> For the servers running Windows/Mixed security:
> -Which NT groups are granted permissions to which databases
> -What permissions are the NT groups granted to which databases
> I know that this is possible to obtain through the gui, by running
> Enterprise Manager and looking at Security > Logins > Database Access, but
it
> must also be stored in the data dictionary somewhere.
> Would you know which views contain this information?
> Effectively, how do I get a comprehensive report on NT Group access to SQL
> Server dbs?
> We have a mix of dbs from 6.5 up to 2000. Our platforms are across NT to
> WIN 2003.