priveledges

[randy]

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.

[marist89]

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

[randy]

thanks