While trying to replicate the inserted data from ASE to IQ,
you may get the following error on your IQ tables: “Permission
denied: you do not have permission to insert into "<TABLE_NAME>"
table.”
Replication Server needs access to update the table in the manner in which data or DDL comes across. Therefore, Sybase recommends granting full permission to the user that the Replication Server is using to apply commands to the target table(s).
To grant full permission on the target Sybase IQ tables, follow these steps:
Connect to the database using Sybase Central.
Expand the Tables folder.
Right-click on the table name.
Select the Permission tab and click the Grant button.
Select the user to grant full table access.
