Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXECUTE ANY CLASS Privilege

JhilJun 5 2020 — edited Jun 7 2020

Dear Experts,

We have received an request to provide following privilege to Appl users.

=>  to create/update/delete jobs to one application schema.

SQL> grant CREATE JOB to <user_name>;

SQL> grant EXECUTE ANY CLASS to <user_name>;

Question is : Do we need 2nd privilege (execute any class) to  update/delete jobs ?

DB Version is : 12.2

Thanks

This post has been answered by GregV on Jun 6 2020
Jump to Answer
Comments
Post Details
Added on Jun 5 2020
4 comments
1,295 views