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