Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.34 DBA_USERS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.34 DBA_USERS

The DBA_USERS view provides information about all users of the database.

Name

Type

Description

Username

TEXT

User name of the user.

user_id

OID

ID number of the user.

password

VARCHAR2(30)

The password (encrypted) of the user.

account_status

VARCHAR2(32)

The current status of the account. Possible values are:

      EXPIRED & LOCKED

      OPEN

      LOCKED

lock_date

TIMESTAMP W/O ZONE

Included for compatibility only. The value is always NULL.

expiry_date

TIMESTAMP W/O ZONE

The expiration date of the account.

default_tablespace

VARCHAR2(30)

The default tablespace associated with the account.

temporary_tablespace

VARCHAR2(30)

Included for compatibility only. The value will always be '' (an empty string).

created

TIMESTAMP W/O ZONE

Included for compatibility only. The value is always NULL.

profile

VARCHAR2(30)

Included for compatibility only. The value is always NULL.

initial_rsrc_consumer_group

VARCHAR2(30)

Included for compatibility only. The value is always NULL.

external_name

VARCHAR2

(4000)

Included for compatibility only. The value is always NULL.

Previous PageTable Of ContentsNext Page