Create Visual Guard Repository in Oracle

You must execute following command to 'create new user with enough privileges in Oracle', before creating a new repository.

Caution
For 12c and above Copy alter session set "_ORACLE_SCRIPT"=true;

• Create your user

  Copy

  CREATE USER <YourUser> IDENTIFIED BY <YourPassword>
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP;

• Assign required roles to your user for creating a new repository

  Copy

  GRANT "DBA" TO <YourUser> WITH ADMIN OPTION;
  ALTER USER <YourUser> DEFAULT ROLE "DBA";

• Assign required system privileges to your user for creating a new repository

  Copy

  GRANT UNLIMITED TABLESPACE TO <YourUser> WITH ADMIN OPTION;