You must add the ASE Replicator system user (or Maintenance User) to the remote server, and you must grant permissions to that user in each replicate database.
To grant ASE Replicator permissions in the replicate
database
Log in to the remote (replicate database) server with either a System Administrator or System Security Officer user role.
Create the ASE Replicator system user (or Maintenance User) login ID in the replicate database server:
use master sp_addlogin rep_login, passwd
where rep_login is the user login ID of the ASE Replicator system user (or Maintenance User), and passwd is the password for that user login.
Add the ASE Replicator system user (or Maintenance User) to each replicate database:
use rdb sp_adduser rep_login, rep_user
where rdb is the name of the replicate database, rep_login is the user login ID of the ASE Replicator system user (or Maintenance User), and rep_user is the user name of the ASE Replicator system user (or Maintenance User) in the replicate database.
The user name (rep_user)
is optional. If you want the user name in the database to be the
same as the user login ID (rep_login),
you need not specify the user name in sp_adduser.
Grant select permission on the syspartitions table to the ASE Replicator system user (or Maintenance User) in each replicate database:
grant select on syspartitions to rep_user
where rep_user is the user name of the ASE Replicator system user (or Maintenance User).
Grant create table permission to the ASE Replicator system user (or Maintenance User) in each replicate database:
grant create table to rep_user
where rep_user is the user name of the ASE Replicator system user (or Maintenance User).
If there are existing replicate tables and stored procedures in a replicate database, you must grant all object access permission on each replicate object to the ASE Replicator system user (or Maintenance User).
In each replicate database, grant all object access permission to the ASE Replicator system user (or Maintenance User) on each replicate table:
grant all on table_name to rep_user
where table_name is the name of a table in the replicate database, and rep_user is the user name of the ASE Replicator system user (or Maintenance User).
In each replicate database, grant all object access permission to the ASE Replicator system user (or Maintenance User) on each replicate stored procedure:
grant all on proc_name to rep_user
where proc_name is the name of a stored procedure in the replicate database, and rep_user is the user name of the ASE Replicator system user (or Maintenance User).
You must perform steps 3 through 6 for each replicate
database.
