solidDB Help : solidDB reference : SQL: Database system tables and system views : System tables : SYS_USERS
  
SYS_USERS
The SYS_USERS table lists information about users and roles.
The columns in the SYS_USERS system table are described in the following table:
 
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.
Go up to
System tables