In your development environment if you have locked down permissions for developers, but still need them to execute stored procedures you will need to grant execute rights each time a new stored procedure is generated. In this tip I will show you a way of doing this automatically each time a new stored procedure is created without granting your developers additional permissions.  Read more...

Create A role and grant it a permission on a DB Schemas.  Read more...

Scripts permissions/roles for db user across all databases.  Read more...

Grant permissions to specific objects in Database using dynamic SQL.  Read more...