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.

Table 8-6 lists the mask values for each of the four permissions.

**Table 8-6: Permission bitmask values in the rs_users system table**
Permission	Mask value
sa	0x0001
connect source	0x0002
create object	0x0004
primary subscribe	0x0008

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