Granting permissions to the maintenance user

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

To grant permissions:

  1. Log in to the Adaptive Server as the System Administrator or as the Database Owner, and enter:

    use standby_database
  2. Grant replication_role to the maintenance user. replication_role ensures that the maintenance user can execute truncate table at the standby database.

    sp_role “grant”, replication_role, maintenance_user
  3. Execute this command for each table:

    grant all on table_name to maintenance_user