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.
Permission | Operations the Permission Authorizes |
---|---|
replication_role | Manage replication operations |
delete any 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 |
|
select any table | select |
truncate any table | truncate table |
update any table |
|