rs_users

Stores a row for each user with access to the Replication Server.

Column

Datatype

Description

username

varchar(30)

Name of the user.

uid

rs_id

ID of the user.

attributes int
Account and password status and settings:
  • 0x000 is default.
  • 0x0001 – initial password.
  • 0x0002 – account locked.
  • 0x0004 – maximum failed attempts lock.
  • 0x0008 – must reset password on this login.
  • 0x0010 – password does not expire.
  • 0x0020 – login is not used.
Attributes values depend on the user and permissions granted. 0x0000 is valid.
expiration_interval smallint

Password expiration for the user in number of days.

failed_attempts smallint

Number of failed login attempts.

lock_date datetime

Date the account was locked.

last_login datetime

Date of the last login.

password

varchar(30)

Password.

password_date datetime

Date of the last password change for the user.

permissions

smallint

Mask indicating roles a user can have:

  • 0x0001 – sa.

  • 0x0002 – connect source.

  • 0x0004 – create object.

  • 0x0008 – primary subscribe.

use_enc_password

int

  • 0 – use normal passwords.

  • 1 – use encrypted passwords.

enc_password

varchar(66)

Encrypted password.

Indexes

  • Unique index on (username)

  • Unique index on (uid)