PASSWORDS System Table Description

Description

Maintains user and password data for all defined users in the current database.

Fields

Field Type Description

USERNAME

string

Name of user

ZONE

varchar(128)

Unused.

VERIFIER

string

Internal string used for verifying user privileges.

SALT

string

Encrypted password

FLAGS

integer

0 if the user was created with CREATE USER and not with EXTERNAL and 1 if the user was created with CREATE USER…​ EXTERNAL, designating that this user’s credentials should be verified via an external LDAP server. This field is reserved for future use.

Indexes

Primary Index: PASSWORDS..PRIMARY_KEY on field: USERNAME