USERS
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 | DISABLED) |
|
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)