ERSSD User Administration

You can change ERSSD user paswords, add users, and assign permissions.

There are only two users in the ERSSD, the primary user, who also acts as system administrator, and the maintenance user. You can find their names and passwords in the configuration file. You can do the following to change the user password:

Use alter user to alter the primary user password.
Use alter connection to alter the maintenance user password.

Both these commands alter the password at Replication Server as well as at ERSSD, and update the Replication Server configuration file.

For more information on these commands see the Replication Server Reference Manual.

To add a user at the ERSSD, use isql to access the ERSSD as the primary user and execute grant connect to username identified by password.

To give a user permission to read the Replication Server system tables, execute the command grant membership in group rs_systabgroup to username.

To grant sa privileges to a user, execute grant dba to username.