Granting create object Permission to the rs_username User

Grant create object permission to the user ID specified by the Replication Agent rs_username parameter.

The rs_username user must have create object permission before Replication Agent can use it to create replication definitions from Replication Server. You must grant this permission manually from the RSSD.

  1. Log in to Replication Server:
    isql -Usa -P -SSAMPLE_RS
  2. Enter:
    grant create object to SAMPLE_RS_ra
    go

    where SAMPLE_RS_ra is the value for the rs_username parameter you entered in the resource file.

  3. Log in to the RSSD:
    isql -USAMPLE_RS_RSSD_prim -PSAMPLE_RS_RSSD_prim_ps
    -SSAMPLE_RS_RSSD

    where SAMPLE_RS_RSSD, SAMPLE_RS_RSSD_prim, SAMPLE_RS_RSSD_prim_ps are the RSSD database name, user ID, and password needed to log in to the RSSD.

  4. Verify that the rs_username user has create object permission:
    select * from rs_users where username = 'SAMPLE_RS_ra'
    go

    The rs_users system table should now indicate that the rs_username user has create object permission.