Database Security Products (MOSC)

MOSC Banner

ORA-47410: Realm violation for GRANT on CREATE TABLE .. please urgent

edited Dec 9, 2025 10:14PM in Database Security Products (MOSC) 3 commentsAnswered

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(

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