SAP IQ Replicate Database Permissions

To apply transactions in a replicate database, Replication Server and SAP IQ require a maintenance user ID.

Before replication can start, you must define the maintenance user ID at the SAP IQ data server and grant authority to the ID to apply transactions in the replicate database. The maintenance user ID must have these permissions in the SAP IQ replicate database:

RESOURCE authority to create worktables and temporary indexes.
EXECUTE permission to run the sp_iqwho stored procedure.
GRANT ALL permission on all replicate tables.
UPDATE authority on all replicate tables and EXECUTE authority on all replicate stored procedures.

Granting Authority to a Maintenance User ID
Grant DBA and RESOURCE authority if you are starting with a simple setup or are testing replication to SAP IQ.

Parent topic: Replication from Oracle to Sybase IQ Using Real-Time Loading