SQLTeam.com | Weblogs | Forums

Permission on roles


#1

Hello,

If all of my data are accessed through Stored procedures and I have the EXEC permission for a particular role do I need to grant permissions on the tables too? The stored procedures INSERT, UPDATE and SELECT data.

Thank you in advance.


#2

No, you only need to grant EXECUTE permission. You may also revoke or deny all permissions of specific table.


#3

Thank you for your answer!