Granting permissions in the replicate database

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.

StepsTo grant ASE Replicator permissions in the replicate database

  1. Log in to the remote (replicate database) server with either a System Administrator or System Security Officer user role.

  2. 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.

  3. 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.

    NoteThe 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.

  4. 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).

  5. 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).

  6. 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).

NoteYou must perform steps 3 through 6 for each replicate database.