Granting Permissions to the Maintenance User

After adding the standby database, you must grant the necessary permissions to the maintenance user.

1. Log in to the Adaptive Server as the System Administrator or as the Database Owner, and specify the database with which you want to work.
   Enter:

   use standby_database

2. Grant replication_role to the maintenance user.
   Enter:

   sp_role “grant”, replication_role, maintenance_user

   replication_role ensures that the maintenance user can execute truncate table at the standby database.
3. Execute the grant all command for each table.
   Enter:

   grant all on table_name to maintenance_user