eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_USERS

Object Details

Object Name:	ALL_USERS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information about all users of the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
USERNAME	VARCHAR2	(128)	Yes	Name of the user
USER_ID	NUMBER		Yes	ID number of the user
CREATED	DATE		Yes	User creation date
COMMON	VARCHAR2	(3)		Indicates whether this user is Common
ORACLE_MAINTAINED	VARCHAR2	(1)		Denotes whether the user was created, and is maintained, by Oracle-supplied scripts. A user for which this has the value Y must not be changed in any way except by running an Oracle-supplied script.

Query Text

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


SELECT USERNAME
,      USER_ID
,      CREATED
,      COMMON
,      ORACLE_MAINTAINED
FROM SYS.ALL_USERS;

Dependencies

[top of page]

SYS.ALL_USERS references the following:

SYS: TS$; USER$

SYS.ALL_USERS is referenced by following:

DVSYS: CONFIGURE_DV - show dependent code; DBMS_MACUTL - show dependent code
LBACSYS: LBAC_POLICY_ADMIN - show dependent code
PUBLIC: ALL_USERS
SYS: ALL_APPLY_ERROR; ALL_CAPTURE_PREPARED_SCHEMAS; ALL_REPCATLOG; ALL_REPCAT_REFRESH_TEMPLATES; ALL_REPCAT_TEMPLATE_OBJECTS; ALL_REPCAT_TEMPLATE_PARMS; ALL_REPCAT_TEMPLATE_SITES; ALL_REPCAT_USER_AUTHORIZATIONS; ALL_REPCAT_USER_PARM_VALUES; ALL_REPGENERATED; ALL_REPGENOBJECTS; ALL_REPGROUP_PRIVILEGES; ALL_REPOBJECT; ALL_REPPROP; DBA_REPCAT_USER_AUTHORIZATIONS; DBMS_ASSERT - show dependent code; DBMS_DEFERGEN - show dependent code; DBMS_REPCAT_RGT_CHK - show dependent code; LOGMNR$SCHEMA_ALLKEY_SUPLOG; PRVT_ACCESS_ADVISOR - show dependent code; PRVT_TUNE_MVIEW - show dependent code; PRVT_WORKLOAD - show dependent code; USER_REPCAT_REFRESH_TEMPLATES; USER_REPCAT_TEMPLATE_OBJECTS; USER_REPCAT_TEMPLATE_PARMS; USER_REPCAT_TEMPLATE_SITES; USER_REPCAT_USER_AUTHORIZATION; USER_REPCAT_USER_PARM_VALUES; USER_REPGROUP_PRIVILEGES; VALIDATE_ODM - show dependent code; XDB_MIGRATESCHEMA - show dependent code