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

password

varchar(30)

Password

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)