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,which is used for communication between Replication Agent and Replication Server, must have create object permission before it can be used to create a replication definition. You must grant this permission manually from Replication Server.

  1. Log in to Replication Server:
    isql -Usa -Psa_pass -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. Connect to the RSSD:
    1>connect
    2>go
  4. Verify that the rs_username user has create object permission:
    1>rs_helpuser
    2>go
    If rs_username has create object permission, the permission is displayed. For example:
    SAMPLE_RS_ra connect source, create object
    
Related tasks
Creating a Database Replication Definition
Creating a Database Replication Subscription