-
Assuming the dba wants to give a user the priveledge
to execute only 4 procedures (PROC_1,PROC_2, PROC_3, PROC_4)
How would you grant priveledge to a user
NOTE: I do not want to grant the user
EXECUTE ANY PROCEDURE priveledge.
NOTE: I did not find this in any docs.
-
1. logon to the owner's schema
2. GRANT EXECUTE ON PROC_1 TO username
3. GRANT EXECUTE ON PROC_2 TO username
4. GRANT EXECUTE ON PROC_3 TO username
5. GRANT EXECUTE ON PROC_4 TO username
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|