March 17, 2010 at 6:02 pm
is there a way to get the list of users or logins that have access to perform queries via SQL Server Mgmt Studio for the whole database?
March 17, 2010 at 11:04 pm
If you want to list out all the Logins with permissions then you can use sysXlogins table in master DB , similarly in a database you can query out from sysusers table, both these tables contain all the info abt the users associated with the server as well as with the DB
March 17, 2010 at 11:23 pm
Check out my response to the same question over on ask.sqlservercentral.com
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 7:15 am
If you want something simple and quick just for the database you can issue:
SELECT user_name(grantee_principal_id) [User_name]
,permission_name
,class_desc
,state_desc
FROM sys.database_permissions
ORDER BY user_name(grantee_principal_id)
March 18, 2010 at 6:52 pm
exactly what i needed it! thank you all of you 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply