Browse by Tags

• script
• security

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