Search code examples
oracle11gjobs

Can a non dba user create oracle job?


Hi i have connected to oracle as a non dba user (ie, it has no 'dba' privilege).I tried to create an oracle JOB with this user. But I couldn't. Is it possible to do it as a non dba user? (Also ,before creating the Job i tried to get what's the current maximum id of existing JOBs.That also I couldn't)


Solution

  • You don't need DBA privileges to creae a job.

    For further details check the Security Model chapter in the Oracle documentation:

    DBMS_JOBS

    DBMS_SCHEDULER