I have a reader user. Is there any way to give that user exec procedures that is not insert update delete? Only select procs..or stop him from running this kind of proc
Asked
Active
Viewed 98 times
0
-
2Which dbms are you using? In general I wouldn't expect grant execute on a procedure to give any other permissions. – jarlh Sep 27 '21 at 07:50
-
This may help you https://stackoverflow.com/questions/5428406/grant-execute-permission-for-a-user-on-all-stored-procedures-in-database – Shreyas Prakash Sep 27 '21 at 07:52