Browse by Tags

All Tags » sql server » permission   (RSS)
Let a user with minimal privileges see another user, simple with TSQL - SQL Server 2005
11 March 08 05:05 PM | SQL Master | 2 Comments   
You may be aware that by default, users that have minimal privileges cannot see other users in the sys.database_principals and sys.server_principals catalog views. This means that a user with minimal privileges that owns a table cannot see other users Read More...
TSQL to generate GRANT statements from a database
17 August 07 03:45 AM | SQL Master | 2 Comments   
select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions p inner join sys.objects Read More...