Setting up the Maintenance User involves:
Adding the Maintenance User login to the standby data server
Granting the Replication role to the Maintenance User login
You need not add the Maintenance User to the standby database, because when you materialize the standby database, users in the primary database are copied to the standby database.
Use the following procedure to set up the Maintenance User login in the standby data server.
You must have a System Administrator user role in the
standby Adaptive Server to perform this procedure.
To set up the Maintenance User in the standby
data server
Log in to the standby Adaptive Server with a System Administrator user role.
Add the Maintenance User login to the standby data server:
use master sp_addlogin mra_maint, mra_maint_pwd, sdb
where:
mra_maint is the Maintenance User login name.
mra_maint_pwd is the password for the Maintenance User.
sdb is the name of the standby database.
Grant the Replication role to the Maintenance User:
grant role replication_role to mra_maint
where mra_maint is the Maintenance User login name.
After you set up the Maintenance User in the standby data server, verify that the Maintenance User can log in to the standby data server.
