Creating an Oracle user and granting permissions

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

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 the following command to create an Oracle user named “RA_USER” 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 ALTER ANY PROCEDURE TO "RA_USER";
GRANT CREATE SESSION TO "RA_USER";
GRANT CREATE TABLE TO "RA_USER";
GRANT CREATE 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 CREATE SEQUENCE 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.USER$ TO "RA_USER";
GRANT SELECT ON SYS.SEQ$ TO "RA_USER";
GRANT SELECT ON SYS.IND$ TO "RA_USER";