My Oracle Support Banner

Getting Error In Altering Restricted Parameters In VAULT Protected Database (Doc ID 2600388.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Trying to edit a rule in the rule set.  For example: Trying to edit "Allow fine grained control for Alter System" rule set to allow a specific user to alter the parameters which are restricted.  Issue the following command in the rule:


   e.g., SYS_CONTEXT ('USERENV','SESSION_USER')='<username>'

But when trying to edit the rule set and add the new rule, the following error is returned:

ORA-47426: The object or its parent object belongs to a Database Vault policy. ORA-06512: at "DVSYS.DBMS_MACADM", line 1320 ORA-06512: at line 1



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.