Creating Oracle User and Grant Permissions

Create an Oracle database user for use by Replication Agent when connected to the primary database.

Note:

Permission to grant access to objects owned by “SYS” may require the command to be executed by an Oracle user with sysdba privileges.

Use SQLPLUS to connect to the primary database as a system administrator and run these commands to create an Oracle user named “RA_USER,” specified by pds_username, with the password “sybase,” and grant permissions to the user:

CREATE USER RA_USER PROFILE "DEFAULT" IDENTIFIED

BY "sybase" DEFAULT TABLESPACE "USERS" ACCOUNT

UNLOCK;

GRANT "CONNECT" TO RA_USER;

GRANT "RESOURCE" TO RA_USER;

GRANT "SELECT_CATALOG_ROLE" TO RA_USER;

GRANT ALTER SESSION TO RA_USER;

GRANT ALTER SYSTEM TO RA_USER;

GRANT EXECUTE ON "SYS"."DBMS_FLASHBACK" To RA_USER;

GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO RA_USER;

GRANT ALTER ANY PROCEDURE TO RA_USER;

GRANT CREATE SESSION TO RA_USER;

GRANT CREATE TABLE TO RA_USER;

GRANT ALTER ANY TABLE TO RA_USER;

GRANT DROP ANY TABLE TO RA_USER;

GRANT CREATE PROCEDURE TO RA_USER;

GRANT DROP ANY PROCEDURE TO RA_USER;

GRANT CREATE PUBLIC SYNONYM TO RA_USER;

GRANT DROP PUBLIC SYNONYM TO RA_USER;

GRANT SELECT ON SYS.OBJ$ TO RA_USER;

GRANT SELECT ON SYS.LOB$ TO RA_USER;

GRANT SELECT ON SYS.COLLECTION$ TO RA_USER;

GRANT SELECT ON SYS.CON$ TO RA_USER;

GRANT SELECT ON SYS.COLTYPE$ TO RA_USER;

GRANT SELECT ON SYS.COL$ TO RA_USER;

GRANT SELECT ON SYS.CDEF$ TO RA_USER;

GRANT SELECT ON SYS.SNAP$ TO RA_USER;

GRANT SELECT ON SYS.TS$ TO RA_USER;

GRANT SELECT ON SYS.USER$ TO RA_USER;

GRANT SELECT ON SYS.SEQ$ TO RA_USER;

GRANT SELECT ON SYS.IND$ TO RA_USER;

GRANT SELECT ON SYS.TAB$ to RA_USER;

GRANT SELECT ON SYS.TABPART$ to RA_USER;

GRANT SELECT ON SYS.TABCOMPART$ to RA_USER;

GRANT SELECT ON SYS.TABSUBPART$ to RA_USER;

GRANT SELECT ON SYS.NTAB$ to RA_USER;

GRANT SELECT ON SYS.INDPART$ to RA_USER;

GRANT SELECT ON SYS.INDCOMPART$ to RA_USER;

GRANT SELECT ON SYS.INDSUBPART$ to RA_USER;

GRANT SELECT ON SYS.LOBCOMPPART$ to RA_USER;

GRANT SELECT ON SYS.LOBFRAG$ to RA_USER;

GRANT SELECT ON SYS.MLOG$ to RA_USER;

GRANT SELECT ON SYS.PROCEDUREINFO$ to RA_USER;

GRANT SELECT ON SYS.ARGUMENT$ to RA_USER;

GRANT SELECT ON SYS.TYPE$ to RA_USER;

GRANT SELECT ON SYS.ATTRIBUTE$ to RA_USER;

GRANT SELECT ON SYS.CCOL$ to RA_USER;

GRANT SELECT ON "SYS"."RECYCLEBIN$" TO RA_USER;

GRANT SELECT ON "SYS"."OPQTYPE$" TO RA_USER;

See the Replication Agent Primary Database Guide.