Sybase IQ Replicate Database Permissions

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

Before replication can start, you must define the maintenance user ID at the Sybase 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 Sybase 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 Sybase IQ.

Parent topic: Sybase IQ as Replicate Data Server