FirebirdSQL logo
 Security tablesCharacter Sets and Collations 

PLG$SRP

User and authentication information of the Srp user manager, used for authentication by the Srp family of authentication plugins.

Column Name Data Type Description

PLG$USER_NAME

VARCHAR(63)

Username

PLG$VERIFIER

VARBINARY(128)

SRP verifier[1]

PLG$SALT

VARBINARY(32)

User-specific salt

PLG$COMMENT

BLOB TEXT

Comment text

PLG$FIRST

VARCHAR(32)

Firstname

PLG$MIDDLE

VARCHAR(32)

Middle name

PLG$LAST

VARCHAR(32)

Lastname

PLG$ATTRIBUTES

BLOB TEXT

User attributes (a.k.a. tags)

PLG$ACTIVE

BOOLEAN

Active or inactive user

PLG$USERS

User and authentication information of the Legacy_UserManager user manager, used for authentication by the Legacy_Auth authentication plugins.

Column Name Data Type Description

PLG$USER_NAME

VARCHAR(63)

Username

PLG$GROUP_NAME

VARCHAR(63)

Group name

PLG$UID

INTEGER

User id

PLG$GID

INTEGER

Group id

PLG$PASSWD

VARBINARY(64)

Password hash

PLG$COMMENT

BLOB TEXT

Comment text

PLG$FIRST_NAME

VARCHAR(32)

Firstname

PLG$MIDDLE_NAME

VARCHAR(32)

Middle name

PLG$LAST_NAME

VARCHAR(32)

Lastname