Browse by Tags

All Tags » sql server » access » grant (RSS)
TSQL to generate GRANT statements from a database
Published 17 August 7 5:45 AM | SSQA.net
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...
Filed under: , , , , , ,