Command(s) to resolve error "insufficient privileges" - Oracle DBA

Q.  While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message “insufficient privileges”. Which command(s) would you use to resolve this error?

- Published on 28 Jul 15

a. GRANT dba TO dbmgr;
b. GRANT connects TO dbmgr;
c. GRANT resource TO dbmgr;
d. GRANT manage scheduler TO dbmgr;
e. a and d

ANSWER: a and d

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲