Browse by Tags

All Tags » performance » system   (RSS)
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...