Hello,
Situation: I have one user Adam, I want to grant him read only to few procedures.
My understanding: As per far as I know, If I grant execute, he wont be able to edit the procedure but he can execute it. Correct me if I am wrong.
What if: If a user doesn't have write access to a table, but has access to execute a stored procedure that writes to that table, what happens when they run that procedure? Does it work, or fail because they don't have write access to the table?
Question: How can I grant a read only to a procedure? A user should not be able to edit/execute the procedure.
Thank you