If a user has execute permission on a stored procedure, will that automatically grant insert/update/delete permission thats embedded in stored proc.
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.