The system table DOMAIN.USERS contains all database users.
OWNER |
CHAR(32) |
Name of the owner of the database user |
GROUPNAME |
CHAR(32) |
Name of the group |
USERNAME |
CHAR(32) |
Name of the database user |
USERMODE |
CHAR(8) |
Class of the database user (SYSDBA | DBA | RESOURCE | STANDARD) |
CONNECTMODE |
CHAR(8) |
Type of connection (MULTIPLE | SINGLE) |
MAXTIMEOUT |
FIXED(10) |
TIMEOUT value |
COSTWARNING |
FIXED(10) |
COSTWARNING value |
COSTLIMIT |
FIXED(10) |
COSTLIMIT value |
DEFAULTCODE |
CHAR(7) |
Default value for code attribute |
CREATEDATE |
DATE |
Date on which the database user was created |
CREATETIME |
TIME |
Time at which the database user was created |
ALTERDATE |
DATE |
Date on which the database user was changed |
ALTERTIME |
TIME |
Time at which the database user was changed |
PWCREADATE |
DATE |
Creation date of the password |
PWCREATIME |
TIME |
Creation time of the password |
SERVERDB |
CHAR(18) |
Database name |
SERVERNODE |
CHAR(64) |
Name of the database computer |
USER_ID |
FIXED(10) |
ID of the database user |
ISREPLICATIONUSER |
CHAR(3) |
Indicates whether the database user can control and monitor database replication (YES | NO) |
COMMENT |
CLOB |
Comment on the database user |
Evaluating System Tables, USERS
Database Administration, Database Users
SQL Reference Manual, User Name (user_name)