Permissions Required for Replication Server Maintenance User

After you install Replication Server and before you use rs_init for configuring your replication system, assign the appropriate Adaptive Server permisssions to the Replication Server maintenance user.

Adaptive Server Permissions Required for Replication Server Maintenance User
Permission Operations the Permission Authorizes
replication_role Manage replication operations
delete any table
  • delete table
  • lock table
execute any procedure execute procedure_name
execute any function execute sql_function_name
identity_insert any table set identity_insert {on | off}
identity_update any table set identity_update {on | off}
insert any table
  • insert
  • lock table
select any table select
truncate any table truncate table
update any table
  • update
  • lock table
  • writetext