Updated on 2024-05-07 GMT+08:00

ADM_USERS

ADM_USERS displays information about all database users. This view is accessible only to system administrators. This view exists in both PG_CATALOG and SYS schema.

Table 1 ADM_USERS columns

Name

Type

Description

username

character varying(128)

Username.

user_id

oid

User ID.

account_status

character varying(32)

Account status.
  • null: The account is the initial system administrator with the highest permission.
  • 0: normal.
  • 1: The account is locked for a specific period of time because the number of failed login attempts exceeds the threshold.
  • 2: The account is locked by the administrator.

lock_date

timestamp with time zone

By default, the creation date of the account is displayed. If the account is locked by the administrator or the account is locked because the number of login failures exceeds the threshold, the date when the account is locked is displayed. The value is null for the initial system administrator.

expiry_date

timestamp with time zone

Account expiration date.

default_tablespace

character varying(4000)

Default tablespace for storing data.

temporary_tablespace

character varying(4000)

Name of the default tablespace or tablespace group of a temporary table.

local_temp_tablespace

character varying(30)

Not supported. The default value is NULL.

created

timestamp with time zone

Date when a user is created.

profile

character varying(128)

Not supported. The default value is NULL.

initial_rsrc_consumer_group

character varying(128)

Not supported. The default value is NULL.

external_name

character varying(4000)

Not supported. The default value is NULL.

password_versions

character varying(12)

Encryption mode of the account password. The value can be MD5, SHA256, or SM3.

editions_enabled

character varying(1)

Not supported. The default value is NULL.

authentication_type

text

Indicates the authentication mechanism of the user.

proxy_only_connect

character varying(1)

Not supported. The default value is NULL.

common

character varying(3)

Not supported. The default value is NULL.

last_login

timestamp with time zone

Last login.

oracle_maintained

character varying(1)

Not supported. The default value is NULL.

inherited

character varying(3)

Not supported. The default value is NULL.

default_collation

character varying(100)

Default collation of the user schema.

implicit

character varying(3)

Not supported. The default value is NULL.

all_shard

character varying(3)

Not supported. The default value is NULL.

password_change_date

timestamp with time zone

Date when the user password was set last time.