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 APRIL 09, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 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



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms