Privileges for Capturing from Oracle Data Vault

Grant the following privileges connected as SYS user in Oracle database. These privileges are set for Extract and Replicat user credentials:

• EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE ('userID','*',
  GRANT_OPTIONAL_PRIVILEGES=>'*');
  GRANT DV_GOLDENGATE_ADMIN, DV_GOLDENGATE_REDO_ACCESS to userID;

• Grant Replicat the privileges in DBMS_MACADM.ADD_AUTH_TO_REALM if applying to a realm.

  Connect as Database Vault owner and execute the following scripts:

  
  BEGIN
  DVSYS.DBMS_MACADM.ADD_AUTH_TO_REALM(
  REALM_NAME => 'Oracle Default Component Protection Realm',GRANTEE => 'userID',AUTH_OPTIONS => 1) ;
  END ;
  /
  EXECUTE_DBMS_MACADM.AUTHORIZE_DDL('SYS', 'SYSTEM');

• For DDL replication, grant the following as the Database Vault owner:

  EXECUTE DBMS_MACADM.AUTHORIZE_DDL
  (‘userID', ‘SCHEMA FOR DDL’);