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.
[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