ORA-47410: Realm violation for GRANT on CREATE TABLE .. please urgent
Hi,
The User Access Administrator, assigned the UAA_ROLE, manages user permissions for granting and revoking privileges. After implementing Database Vault, they are unable to grant system privileges, such as CREATE TABLE, to users. However, they can still grant object privileges, as demonstrated in the example below. Please provide your support to resolve this issue.
SQL> BEGIN
DVSYS.DBMS_MACADM.CREATE_REALM(
realm_name => 'REALM_EAIR',
description => 'Realm to protect all objects in EAIRPRD schema',
enabled => DBMS_MACUTL.G_YES,
realm_type => 0, -- 0 mean regular realm
audit_options => DBMS_MACUTL.G_REALM_AUDIT_FAIL);
END;
/
SQL> BEGIN
DVSYS.DBMS_MACADM.ADD_OBJECT_TO_REALM(