Troubleshooting guide

ManualsBrandsSAP ManualsComputer equipmentDB:ODBC

GRANT SELECT ON SYS.ATTRIBUTE$ TO RA_USER;

GRANT SELECT ON SYS.CCOL$ TO RA_USER;

GRANT SELECT ON SYS.CDEF$ TO RA_USER;

GRANT SELECT ON SYS.COL$ TO RA_USER;

GRANT SELECT ON SYS.COLLECTION$ TO RA_USER;

GRANT SELECT ON SYS.COLTYPE$ TO RA_USER;

GRANT SELECT ON SYS.CON$ TO RA_USER;

GRANT SELECT ON SYS.DEFERRED_STG$ TO RA_USER;

GRANT SELECT on SYS.ICOL$ TO RA_USER;

GRANT SELECT ON SYS.IND$ TO RA_USER;

GRANT SELECT ON SYS.INDCOMPART$ TO RA_USER;

GRANT SELECT ON SYS.INDPART$ TO RA_USER;

GRANT SELECT ON SYS.INDSUBPART$ TO RA_USER;

GRANT SELECT ON SYS.LOB$ 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.NTAB$ TO RA_USER;

GRANT SELECT ON SYS.OBJ$ TO RA_USER;

GRANT SELECT ON SYS.OPQTYPE$ TO RA_USER;

GRANT SELECT ON SYS.PARTOBJ$ TO RA_USER;

GRANT SELECT ON SYS.PROCEDUREINFO$ TO RA_USER;

GRANT SELECT ON SYS.RECYCLEBIN$ TO RA_USER;

GRANT SELECT ON SYS.SEG$ TO RA_USER;

GRANT SELECT ON SYS.SEQ$ TO RA_USER;

GRANT SELECT ON SYS.SNAP$ TO RA_USER;

GRANT SELECT ON SYS.TAB$ TO RA_USER;

GRANT SELECT ON SYS.TABCOMPART$ TO RA_USER;

GRANT SELECT ON SYS.TABPART$ TO RA_USER;

GRANT SELECT ON SYS.TABSUBPART$ TO RA_USER;

GRANT SELECT ON SYS.TS$ TO RA_USER;

GRANT SELECT ON SYS.TYPE$ TO RA_USER;

GRANT SELECT ON SYS.USER$ TO RA_USER;

GRANT SELECT ON V_$LOGMNR_CONTENTS TO RA_USER;

GRANT SELECT ON V_$LOGMNR_LOGS TO RA_USER;

See the

Replication Agent Primary Database Guide

If you configure the ra_admin_owner user, make sure that these permissions are also

granted:

GRANT CREATE SESSION TO RA_USER;

GRANT CREATE TABLE TO RA_USER;

GRANT CREATE SEQUENCE TO RA_USER;

GRANT CREATE ANY PROCEDURE TO RA_USER;

GRANT SELECT_CATALOG_ROLE TO RA_USER;

Verifying the Oracle User Roles Created by the Replication Agent

Validate the required Oracle settings.

Use SQLPLUS to run this command as the new Oracle user:

select GRANTED_ROLE from USER_ROLE_PRIVS;

GRANTED_ROLE

--------------------

CONNECT

CHAPTER 4: Oracle-to-SAP HANA Database Replication Setup

Quick Start Guide for SAP HANA Database 37