Granting Required Permissions to Maintenance User Role

Grant to the maintenance user role, Adaptive Server permissions for specific operations.

1. Start isql as the user with system administrator privileges on the Adaptive Server that the maintenance user logs into:
   isql –Usa_user -Ppassword -Sdata_server_name
2. Grant the Adaptive Server permissions to the rs_maint_user_role to allow the Replication Server maintenance user the correct privileges to access and update the database_name database:

   use database_name
   go
   grant delete any table to rs_maint_user_role
   go
   grant identity_insert any table to rs_maint_user_role
   go
   grant identity_update any table to rs_maint_user_role
   go
   grant insert any table to rs_maint_user_role
   go
   grant select any table to rs_maint_user_role
   go
   grant truncate any table to rs_maint_user_role
   go
   grant update any table to rs_maint_user_role
   go
   grant execute any function to rs_maint_user_role
   go
   grant execute any procedure to rs_maint_user_role
   go

• Permissions Required for Replication Server Maintenance User
  After you install Replication Server and before you use rs_init for configuring your replication system, assign the appropriate Adaptive Server permisssions to the Replication Server maintenance user.