DBA Data[Home] [Help]

VIEW: SYS.CDB_USERS

Source

View Text - Preformatted

SELECT "USERNAME","USER_ID","PASSWORD","ACCOUNT_STATUS","LOCK_DATE","EXPIRY_DATE","DEFAULT_TABLESPACE","TEMPORARY_TABLESPACE","CREATED","PROFILE","INITIAL_RSRC_CONSUMER_GROUP","EXTERNAL_NAME","PASSWORD_VERSIONS","EDITIONS_ENABLED","AUTHENTICATION_TYPE","PROXY_ONLY_CONNECT","COMMON","LAST_LOGIN","ORACLE_MAINTAINED","CON_ID" FROM CONTAINERS("SYS"."DBA_USERS")
View Text - HTML Formatted

SELECT "USERNAME"
, "USER_ID"
, "PASSWORD"
, "ACCOUNT_STATUS"
, "LOCK_DATE"
, "EXPIRY_DATE"
, "DEFAULT_TABLESPACE"
, "TEMPORARY_TABLESPACE"
, "CREATED"
, "PROFILE"
, "INITIAL_RSRC_CONSUMER_GROUP"
, "EXTERNAL_NAME"
, "PASSWORD_VERSIONS"
, "EDITIONS_ENABLED"
, "AUTHENTICATION_TYPE"
, "PROXY_ONLY_CONNECT"
, "COMMON"
, "LAST_LOGIN"
, "ORACLE_MAINTAINED"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_USERS")