If a user has execute permission on a stored procedure, will that automatically grant insert/update/delete permission thats embedded in stored proc.
asked
SP execute permission
It won't grant explicit access to those objects but will allow the procedure to make those inserts/updates/deletes via the procedure to succeed.
Thanks John. So does this mean an user who is not having db_datareader and db_datawriter permissions can execute the stored procedure which contains DML statements
In order for the stored procedure to work in such a fashion, you're going to need to add WITH EXECUTE AS OWNER to the stored procedure.
17 People are following this question.
