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 it can be used to create a replication definition. 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 indicate that the rs_username user has create object permission.