Browse by Tags

Control metada visibility using few 'simple' statements

Published 9 August 7 5:3 AM | SSQA.net

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...

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

Script to find out all the groups contain in the login token for every server principal

Published 17 July 7 10:44 AM | SSQA.net

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...

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