Skip to Main Content
Forums

Database Software

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!

Privileges to run a job by user other than job owner

twrzJan 2 2009 — edited Jan 5 2009
Hi,

Does ALTER privilege on a job have to be granted directly to a user (other than job owner) to run this job? I try to grant it to role, and then this role to a user, but get error:

ORA-27476: "owner.job_name" does not exist
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441

Everything is ok when I grant ALTER on job directly to user or grant create any job.

TWR
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2009
Added on Jan 2 2009
#database-key-features, #scheduler
1 comment
3,377 views