Database Administration (MOSC)

MOSC Banner

privilege using database vault

edited Jan 19, 2020 4:00AM in Database Administration (MOSC) 3 commentsAnswered

Hi

I have a following database setup with Database Vault enabled

SELECT * FROM DBA_DV_STATUS;

NAME                 STATUS

-------------------- -----------

DV_CONFIGURE_STATUS  TRUE

DV_ENABLE_STATUS     TRUE

Schema Owner: T24

DBV backup owner: dbv_owner_backup

Logged on as dbv_owner_backup

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(

realm_name =>'T24_REALM',

object_owner => 'T24',

object_name => '%',

object_type =>'%');

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