USERS

Definition

The system table USERS contains all database users.

Structure

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(10)

Date on which the database user was created

CREATETIME

TIME(8)

Time at which the database user was created

ALTERDATE

DATE(10)

Date on which the database user was changed

ALTERTIME

TIME(8)

Time at which the database user was changed

PWCREADATE

DATE(10)

Creation date of the password

PWCREATIME

TIME(8)

Creation time of the password

SERVERDB

CHAR(18)

Name of the database instance

SERVERNODE

CHAR(64)

Name of the computer of the database instance

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

LONG BYTE

Comment on the database user

See also:

Evaluating System Tables, USERS

Concepts of the Database System, Database Users

SQL Reference Manual, User Name (user_name)