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

VIEW: SYS.DBA_USERS_WITH_DEFPWD

Object Details
Object Name: DBA_USERS_WITH_DEFPWD
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Users that are still using their default passwords

[View Source]

Columns
Name Datatype Length Mandatory Comments
USERNAME VARCHAR2 (128) Yes Name of the user
PRODUCT VARCHAR2 (4000)
Name of the product the user belongs to
Query Text

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


SELECT USERNAME
,      PRODUCT
FROM SYS.DBA_USERS_WITH_DEFPWD;

Dependencies

[top of page]

SYS.DBA_USERS_WITH_DEFPWD references the following:

SchemaSYS
TableDEFAULT_PWD$
TableUSER$
SYS.DBA_USERS_WITH_DEFPWD is referenced by following:

SchemaPUBLIC
SynonymDBA_USERS_WITH_DEFPWD