privilege using database vault
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 =>'%');