Querying the rs_users system table

The rs_users system table in the RSSD contains the login name and password information for Replication Server users.

rs_users also includes a column to identify if the password is encrypted or clear text, and a column to hold the encrypted password.

The rs_users system table also includes a permissions column, which stores the permissions for each login name. The permissions column is a bit-mask of the permissions granted to users.

For example, the following query, executed in the RSSD, lists users who have sa permission:

select username, uid from rs_users
 where permissions & 0x0001 != 0