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.
No, you only need to grant EXECUTE permission. You may also revoke or deny all permissions of specific table.
Thank you for your answer!