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.