Grant to the maintenance
user role, Adaptive Server permissions for specific operations.
Prerequisites
Create the maintenance user role.
- 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
- 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