Column name
|
Data type
|
Description
|
---|---|---|
ID
|
INTEGER
|
User or role identifier.
|
NAME
|
WVARCHAR
|
User or role name.
|
TYPE
|
WVARCHAR
|
User type, either USER or ROLE.
|
PRIV
|
INTEGER
|
Privilege information.
|
PASSW
|
VARBINARY
|
Password in encrypted format.
If the user is authenticated externally, the value is NULL.
|
PRIORITY
|
INTEGER
|
Reserved for future use.
|
PRIVATE
|
INTEGER
|
Specifies whether user is private or public.
|
LOGIN_CATALOG
|
WVARCHAR
|
Reserved for future use.
|
AUTHENTICATION
|
INTEGER
|
Specifies whether user is authenticated internally (0) or externally (1).
|
CONNECTION_LIMIT
|
INTEGER
|
Defines the maximum number of connections for a given user name.
The default value is 0, which means that there is no limit on concurrent connections for the specified user.
|