Grant Permissions in the Database

Use Sybase Central or rs_init to grant the maintenance user permission to access the rs_lastcommit system table and the stored procedures that use it. Use grant all to grant permissions for tables and stored procedures involved in replication.

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 this grant command:

grant all on table_name to maint_user

Note: 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.

Grant Permissions for a Primary Database
If a replicate database holds primary data, then it is also a primary database. In a primary database, special permissions are necessary on two replication objects: subscriptions and request functions.

Parent topic: Manage the Maintenance User