Show TOC

rs_maintusersLocate this document in the navigation structure

Stores the user login names and passwords Replication Server uses to access other Replication Servers and data servers.

Column

Datatype

Description

destid

int

Site ID for the Replication Server or database to be logged into

username

varchar(30)

User name for the Replication Server RSI user or for the database maintenance user

password

varchar(30)

Password

use_enc_password

int

  • 0 – use normal passwords

  • 1 – use encrypted passwords

enc_password

varchar(66)

Stores the current encrypted user password

new_password varchar(66) Stores the new random encrypted password generated for the current expiration interval.
attributes int
Account and password status and settings:
  • 0x0 – initial password. The Replication Server password daemon changes the initial password status to hidden the next time the daemon wakes up.
  • 0x01 – hidden password. Replication Server has changed the initial password to a random password.
password_date datetime

Date of the last password change for the maintenance user.

expiration_interval smallint

Password expiration for the maintenance user in number of days.

Indexes

Unique clustered index on (destid)