Show TOC

Object documentationUSERS Locate this document in the navigation structure

 

The system table DOMAIN.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

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

More Information

Evaluating System Tables, USERS

Database Administration, Database Users

SQL Reference Manual, User Name (user_name)