Database Administration (MOSC)

MOSC Banner

Oracle DV privilege query

edited Feb 21, 2020 8:51AM in Database Administration (MOSC) 6 commentsAnswered

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(

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