Database 19c Vault: OWNER/Manager privileges !

By | |

In Oracle Database 19c, after enabling Database Vault (DV), two key roles are assigned during configuration: DV_OWNER and DV_ACCTMGR. These roles grant specific, powerful privileges for managing Database Vault environments.

After enabling Oracle database vault 19c, and after the creating of two users:

  • Database VAULT Owner: dbv_owner
  • Database VAULT Manager: dbv_manager

List of privileges for the DV Owner as SQL queries:

GRANT "DV_OWNER" TO "DBV_OWNER" WITH ADMIN OPTION;
ALTER USER "DBV_OWNER" DEFAULT ROLE ALL;
GRANT EXECUTE ON "SYS"."DBMS_RLS" TO "DBV_OWNER" WITH GRANT OPTION;

List of privileges for the DV Manager as SQL queries:

GRANT "DV_ACCTMGR" TO "DBV_MANAGER" WITH ADMIN OPTION;
ALTER USER "DBV_MANAGER" DEFAULT ROLE ALL;

Enjoy!

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply