Setting up the ASE Replicator system user

You must create an Adaptive Server user login for ASE Replicator. ASE Replicator uses this login to access the primary database’s transaction log and the Distribution Database. The ASE Replicator system user login must have the Replication role.

To set up the ASE Replicator system user login

Log in to the primary Adaptive Server with a System Administrator or System Security Officer user role.
Create the ASE Replicator system user login ID:
```
use master
sp_addlogin rep_login, passwd
```
where rep_login is the user login ID of the ASE Replicator, and passwd is the password for the ASE Replicator system user.
Assign the Replication role to the ASE Replicator system user login ID:
```
grant role replication_role to rep_login
```
where rep_login is the user login ID of the ASE Replicator system user.
Add the ASE Replicator system user to each primary database that will be a source of data:
```
use pdb
sp_adduser rep_login, rep_user
```
where pdb is the name of the primary database, rep_login is the user login ID of the ASE Replicator system user, and rep_user is the user name of the ASE Replicator system user in the primary 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.
In each primary database, grant create procedure permission to the ASE Replicator system user:
```
grant create procedure to rep_user
```
where rep_user is the user name of the ASE Replicator system user.
In each primary database, grant select permission to the ASE Replicator system user on each table that you want to publish:
```
grant select on table_name to rep_user
```
where table_name is the name of a table in the primary database, and rep_user is the user name of the ASE Replicator system user.
In each primary database, grant execute permission to the ASE Replicator system user on each stored procedure that you want to publish:
```
grant execute on proc_name to rep_user
```
where proc_name is the name of a stored procedure in the primary database, and rep_user is the user name of the ASE Replicator system user.

You must perform steps 4 through 7 for each primary database.