Reporting on System Users

[dhulbert]

I'm trying to pull together a list off all of the users on my SQl 2005 server, the databases they have access to and the permissions they have on each database.

I've found sys.server_principals which seems to list all of the logins on the server the current status (Enabled, Disabled).
but after that I'm getting stuck.

Any pointers would eb appreciated.

Thanks

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[tlbroadbent]

EXEC sp_helplogins

Terry L. Broadbent - DBA

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. (Nathaniel Borenstein)

 

[SQLSister]

Terry, so good to see you again. There are so many times when I think about how much I learned from you when I was a SQL Server newbie.

"NOTHING is more important in a database than integrity." ESquared

 

[tlbroadbent]

SQLSister,

Thanks. It has been a long while since I participated here. I'm glad to see some familiar names are still actively involved.

Terry L. Broadbent - DBA

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents. (Nathaniel Borenstein)

 

[dhulbert]

Cheers Terry that was spot on.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)