After adding the standby database, you must grant the necessary permissions to the maintenance user.
To grant permissions:
Log in to the Adaptive Server as the System Administrator or as the Database Owner, and enter:
use standby_database
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
Execute this command for each table:
grant all on table_name to maintenance_user
