Browse by Tags

• access
• principal
• security
• sql server
• token
• users

Script to find out all the groups contain in the login token for every server principal
17 July 07 08:44 AM | SQL Master | 1 Comments   

The following query will get you the information to find out the groups that contain user login token on that server principal: SELECT name , usage , type FROM sys.login_token ORDER BY usage , type , name go To find any Windows principal in the token Read More...

Filed under: sql server, security, script, login, users, principal, token

Script to check user access on master and associated user database
28 May 07 10:16 AM | SQL Master | 0 Comments   

SELECT name , principal_id , type_desc , is_disabled , default_database_name , default_language_name FROM sys.server_principals WHERE name = 'login_name' go SELECT name , database_id , user_access_desc , state_desc , is_in_standby FROM sys.databases WHERE Read More...

Filed under: security, script, access, login