DBA_USERS
Information about all users of the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USERNAME | VARCHAR2 | (30) | Yes | Name of the user |
USER_ID | NUMBER | Yes | ID number of the user | |
PASSWORD | VARCHAR2 | (30) | Encrypted password | |
ACCOUNT_STATUS | VARCHAR2 | (32) | Yes | |
LOCK_DATE | DATE | |||
EXPIRY_DATE | DATE | |||
DEFAULT_TABLESPACE | VARCHAR2 | (30) | Yes | Default tablespace for data |
TEMPORARY_TABLESPACE | VARCHAR2 | (30) | Yes | Default tablespace for temporary tables |
CREATED | DATE | Yes | User creation date | |
PROFILE | VARCHAR2 | (30) | Yes | User resource profile name |
INITIAL_RSRC_CONSUMER_GROUP | VARCHAR2 | (30) | User's initial consumer group | |
EXTERNAL_NAME | VARCHAR2 | (4000) | User external name |
Usage
cursor cur_schema
is select username
from dba_users
order by username;