Home Forums SQL Server 2008 Security (SS2K8) Table Permissioning RE: Table Permissioning
sqlnaive
SSCoach
Points: 17437
More actions
August 20, 2012 at 6:09 am
#1527544
The following thing works for me for granting execute permissions on all the procedures to a role:
grant EXEC to <rolename>
The same way i was thinking and thats how my mind started dreaming.:-)