Database Security Products (MOSC)

MOSC Banner

ORA-47401: Realm violation for CREATE INDEX on another Schema Table

Hi 

Please I need your support on below case :

User TEST has been granted the DBA role and has also been granted OWNER authorization on the realm custom realm. After implementing Oracle Database Vault, I observed the following behavior:

  • CREATE TABLE on the CUSTOM schema from user test works successfully.
  • However, CREATE INDEX on the same schema fails with a realm violation (ORA-47401).
  • A rule set is in place to restrict DML operations (e.g., SELECT, INSERT, UPDATE, DELETE) by evaluating the dv_sysevent., Which is working fine.

Objective:
I want to ensure that all DDL privileges granted through the DBA role remain fully available to user TEST after Database Vault is enabled, while only DML operations are restricted.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center