Extracting NT User Group privs to dbs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SD - 23 Dec 2005 08:43 GMT

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.

Reply to this Message

m.bohse@quest-consultants.com - 23 Dec 2005 12:07 GMT

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/columnists/cmiller/dumpsqlpermissions.asp
for the download. You might need to register on SQLServercentral
though.
Markus

Reply to this Message

Andy Davis - 23 Dec 2005 12:10 GMT

Hi,
you may find it from system databas table , or may find a script from
www.sql-server-performance.com/forum

:-)

Regards

Signature

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com

> I have been asked to provide the following info. for all our sql server
> databases (of which there are many)
[quoted text clipped - 14 lines]
> We have a mix of dbs from 6.5 up to 2000. Our platforms are across NT to
> WIN 2003.

Reply to this Message