Oracle DV privilege query
Hello All
I have configured 19c pluggable database with database vault and LBS configured via the dbca console
As a sysdba user for pluggable database PDBVAULT
SQL> grant create session , create table , select any table to t24
Following two valut users created
C##DBV_ACCTMGR_BACKUP
C##DBV_OWNER_BACKUP
********************************************************************************************************************************************************************************************************************************
conn c##dbv_owner_backup/Oracle123@PDBVAULT
BEGIN
DVSYS.DBMS_MACADM.CREATE_REALM(
realm_name =>'T24_REALM',
description =>'Realm for objects in T24 schema' ,
enabled =>DBMS_MACUTL.G_YES, --realm enabled
audit_options =>DBMS_MACUTL.G_REALM_AUDIT_FAIL); --audit enabled
END;
/
BEGIN
DVSYS.DBMS_MACADM.ADD_OBJECT_TO_REALM(