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!

how can I revoke execution of dbms_job from users ?

83991Aug 21 2006 — edited Aug 21 2006

I tried "revoke execute on dbms_job from user_X ;"
and got an error that I can not revoke permission I didn't grant .
I don't want that anyone who wants to schedule a job every 10 seconds will be able to do that . I want to permit only users of dba role , to execute this (or other) package .

Thanks ,
Lior .

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2006

Added on Aug 21 2006

4 comments

671 views