Maintenance User Password Protection

Use hide_maintuser_pwd to configure password protection for the maintenance user and restrict maintenance user access to Replication Server.

You can configure hide_maintuser_pwd for a specific Adaptive Server database connection controlled by the Replication Server or at the server level for all Adaptive Server database connections controlled by the Replication Server. To configure hide_maintuser_pwd at the:

Connection level – use create connection or alter connection:

create connection:

create connection to data_server.database 
set error class [to] error_class
set function string class [to] function_class
set username [to] user
[set password [to] passwd]
set hide_maintuser_pwd to ‘{on | off}’
...
go

alter connection:

alter connection to data_server.database 
set hide_maintuser_pwd to ‘{on | off}’
go

Server level – use configure replication server:

configure replication server 
set hide_maintuser_pwd to ‘{on | off}’
go

The default is off.

If multiple connections to the same or a different database controlled by Replication Server share the same maintenance user, Replication Server alters the maintenance user password for all the connections if you set hide_maintuser_pwd on.