Browse by Tags

• access
• login
• metadata
• privileges
• script
• security
• sql server
• token
• tsql
• users
• view

Control metada visibility using few 'simple' statements
09 August 07 03:03 AM | SQL Master | 2 Comments   

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the Read More...

Filed under: security, access, tsql, principal, metadata, privileges, view

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