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	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 set a password last time.