Either Sybase Central or rs_init grants the maintenance user permission to access the rs_lastcommit system table and the stored procedures that use it.
Neither Sybase Central nor rs_init grants permissions to the maintenance user for user tables and stored procedures. You must grant permissions on replicated tables and stored procedures before you can either replicate transactions for replicated tables or replicate executions of the replicated stored procedures.
For each table that is replicated in the database, and for each stored procedure that is executed due to replication, execute the following grant command:
grant all on table_name to maint_user
Among the permissions granted to the maintenance user
is replication_role. If you revoke this
permission, you will not be able to replicate truncate
table unless the maintenance user has been granted sa_role,
owns the table, or is aliased as the Database Owner.
See the Replication Server Heterogeneous Replication Guide for the permissions to grant the maintenance user for non-ASE replicate databases.
