HenryFulmer Yak Posting Veteran
USA 98 Posts
visakh16 Very Important crosS Applying yaK Herder
India 47173 Posts
DonAtWork Flowing Fount of Yak Knowledge
2111 Posts
apparently ON is optional Example: --To Grant execute rights to all stored procedure to a role GRANT EXECUTE TO db_executor where db_executor is a role created by: --Create a new role for executing stored procedures CREATE ROLE db_executor
ScottPletcher Yak Posting Veteran
USA 79 Posts
USE <db_name_to_be_affected> GRANT EXECUTE TO <user_name>
grant permissions to all stored procedures
Posted - 02/21/2013 : 09:16:05
