PASSWORDS System Table Description

Description

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

Fields

Field Type Description

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.

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