[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_USERS

Object Details

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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
FROM SYS.DBA_USERS;

Dependencies

[top of page]

SYS

PROFILE$

PROFNAME$

RESOURCE_GROUP_MAPPING$

TS$

USER$

USER_ASTATUS_MAP

DVSYS

DV$SYS_GRANTEE

DV$SYS_OBJECT_OWNER

PUBLIC

DBA_USERS

SYS

ALL$OLAP2_AWS

ALL_APPLY_ERROR

ALL_REPCAT_USER_PARM_VALUES

DBA_APPLY_CONFLICT_COLUMNS

DBA_LOGSTDBY_SKIP

DBA_PARALLEL_EXECUTE_CHUNKS

DBA_PARALLEL_EXECUTE_TASKS

DBA_REPCAT_USER_PARM_VALUES

DBA_REPGROUP_PRIVILEGES

DBMS_ASH_INTERNAL - show dependent code

DBMS_AUDIT_MGMT - show dependent code

DBMS_CAPTURE_ADM_INTERNAL - show dependent code

DBMS_DBFS_SFS_ADMIN - show dependent code

DBMS_DEFER_SYS_DEFINER - show dependent code

DBMS_DEFER_SYS_PART1 - show dependent code

DBMS_INTERNAL_LOGSTDBY - show dependent code

DBMS_LOGREP_EXP - show dependent code

DBMS_LOGREP_IMP_INTERNAL - show dependent code

DBMS_PARALLEL_EXECUTE_INTERNAL - show dependent code

DBMS_REDEFINITION_INTERNAL - show dependent code

DBMS_REPCAT_ADMIN - show dependent code

DBMS_REPCAT_AUTH - show dependent code

DBMS_REPCAT_OUTPUT - show dependent code

DBMS_REPCAT_RGT_CHK - show dependent code

DBMS_REPCAT_RGT_UTL - show dependent code

DBMS_REPCAT_UTL - show dependent code

DBMS_STREAMS_ADM_UTL - show dependent code

DBMS_STREAMS_AUTH - show dependent code

DBMS_STREAMS_SM - show dependent code

DBMS_SWRF_INTERNAL - show dependent code

DBMS_XDB_HTTP_DIGEST - show dependent code

DBMS_XSTREAM_ADM_INTERNAL - show dependent code

DBMS_XSTREAM_ADM_UTL - show dependent code

DBMS_XSTREAM_AUTH_IVK - show dependent code

USER_FLASHBACK_ARCHIVE_TABLES

USER_REPCAT_USER_PARM_VALUES

XS_DIAG_INT - show dependent code

XDB

DBMS_XMLSTORAGE_MANAGE - show dependent code