Oracle
1Z0-043 · Question #146
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to resolve this error?…
The correct answer is A. GRANT dba TO dbmgr E. GRANT manage scheduler TO dbmgr. See the full explanation below for the reasoning.
Question
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to resolve this error? (Choose two)
Options
- AGRANT dba TO dbmgr
- BGRANT connect TO dbmgr
- CGRANT resource TO dbmgr
- DGRANT hs_admin_role TO dmbgr
- EGRANT manage scheduler TO dbmgr
How the community answered
(48 responses)- A73% (35)
- B4% (2)
- C17% (8)
- D6% (3)
Community Discussion
No community discussion yet for this question.