Enable_DV Error 'ORA-12440: insufficient authorization', While Running As EUS User With Dv_owner Privilege Granted Thru EUS Global Role
(Doc ID 2360316.1)
Last updated on OCTOBER 10, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When trying to enable DV using enable_dv command we get insufficient authorization even though the user has dv_owner granted through EUS global role. It happens with OVD user (EUS global user).
But when DV_ADMIN is granted directly to the EUS user, it works.
SQL> EXEC DBMS_MACADM.ENABLE_DV;
BEGIN DBMS_MACADM.ENABLE_DV; END;
*
ERROR at line 1:
ORA-12440: insufficient authorization for the SYSDBA package
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 3
ORA-06512: at "LBACSYS.OLS_ENFORCEMENT", line 17
ORA-06512: at "DVSYS.DBMS_MACADM", line 2068
ORA-06512: at line 1
SQL> show user
USER is "OVD_GLOBAL_USER"
SQL> select * from session_roles;
ROLE
--------------------------------------------------------------------------------
CONNECT
DBA
DV_SECANALYST
DV_MONITOR
DV_ADMIN
DV_OWNER
DV_ACCTMGR
DV_PUBLIC
DV_PATCH_ADMIN
DV_STREAMS_ADMIN
DV_GOLDENGATE_ADMIN
DV_XSTREAM_ADMIN
DV_GOLDENGATE_REDO_ACCESS
DV_AUDIT_CLEANUP
DV_DATAPUMP_NETWORK_LINK
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |