Enumerate SQL Server Logins and Permissions

Haven't been able to find the answer to this after sever searches. So decided to open the thread myself.

I am trying to write a report enumerating logins in SQL Server and all database-level and object-level permissions granted to each login.

Can someone tell me what system objects I can query to fetch this information?

TIA.

Hi,

You can get the results by querying the following system views(cata log views):

Database-Level Views:

sys.database_permissions
sys.database_principals

Server-Level Views:

sys.server_permissions
sys.sql_logins
sys.server_principals

Thanks & Regards,

Kiran.Y

|||

That's just what I was looking for. Thanks much.

sql

Enterprise manager problem

Edited by moderator XIII: please don't provide valuable passwords!!

hi all

i have a sever problem but really i dont know its cause

at first

server host : storm.syntaxhosting .net

username :egymed_egymed

password : ----

my problem now is when i connect to this server to view and manage my databases that i have created it by the C panel of the site . the peogram " sql server enterprise manager "" stop responding and stop doing any action when i click on the server name that i had already rigesterd it the tree view appears and when i expand any folder like ( managment - security ) it already expand and work ..while clicking on databases category it stop responding (( this occur while trying to deal with any data belonging to the server ((( local server is excellent and working proberly)))

so now i dont know where is the error and i dont know who i contact

is the error in the server to call the hosting

or it in the program ?? i really dont know

please can any one help me and try connecting to this server from this program and tell me where is the wrong

thanks

You mean all databases belong to that server are not accessible from EM? If so it seems to be something wrong with master database.

Anywasy we can try to open Query Analyzer and try to use that database to see what will happen.