Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By mobasha B,
the first procedure GrantOnSchemaToRole will create a role and grnat it user defined permission
on the database schemas.
exec GrantOnSchemaToRole @RoleName='db_Execute', @Permission='execute', @DatabaseName='TestDB'
this will create a role named db_Execute in the database TestDB and grant this role execute permission on all of the DB Schemas.
the sconed procedure GrantOnSchemaToRoleAllServerDBs will run GrantOnSchemaToRole for every database on the server.
Permissions to execute Assemblies...
DTS execute permissions
Written by Ian Treasure
Gethyn posted on the use of execute permissions a while ago (db_executor at...
Database Object Permissions Lost