Information Related to Passwords and Auditing

V$PWFile_Users Information

User Name SYSDBA Privs SYSOPER Privs (Y/N)
DATAPIPE TRUE FALSE
SYS TRUE TRUE

Back to top

All_Def_Audit_Opts Information

Alter Audit Comment Delete Grant Index Insert Lock Rename Select Update Reference Execute
-/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/-

Back to top

DBA_Profiles Information

Profile Resource Name Limit
DEFAULT FAILED_LOGIN_ATTEMPTS 10
DEFAULT PASSWORD_LIFE_TIME UNLIMITED
DEFAULT PASSWORD_REUSE_TIME UNLIMITED
DEFAULT PASSWORD_GRACE_TIME UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION NULL
DEFAULT PASSWORD_LOCK_TIME UNLIMITED
DEFAULT PASSWORD_REUSE_MAX UNLIMITED

Back to top

DBA_Users Information

User Name Lock Date Expiry Date Profile
CLARKEE2 06-May-2011 10:16:28 Null value DEFAULT
DIP 22-Feb-2011 04:43:33 Null value DEFAULT
EDWARDN1 06-May-2011 10:13:26 Null value DEFAULT
FCIBOP001 06-May-2011 10:10:29 Null value DEFAULT
FCIBOP002 06-May-2011 10:10:34 Null value DEFAULT
FCIBOP003 06-May-2011 10:10:37 Null value DEFAULT
FCIBOP004 06-May-2011 10:10:41 Null value DEFAULT
FCIBOP005 06-May-2011 10:10:45 Null value DEFAULT
GREAVET1 06-May-2011 10:14:18 Null value DEFAULT
HOWELLA3 06-May-2011 10:14:42 Null value DEFAULT
JOSEPHJ1 06-May-2011 14:25:35 Null value DEFAULT
JOSEPHJI 06-May-2011 14:25:39 Null value DEFAULT
ORACLE_OCM 22-Feb-2011 04:49:12 Null value DEFAULT
PPS 06-May-2011 10:11:09 Null value DEFAULT
TEST1 06-May-2011 11:27:11 Null value DEFAULT
TSMSYS 22-Feb-2011 04:47:47 Null value DEFAULT
UATTEST02 06-May-2011 11:25:26 Null value DEFAULT
UATTEST03 06-May-2011 11:25:30 Null value DEFAULT
UATTEST04 06-May-2011 11:25:33 Null value DEFAULT
UATTEST05 06-May-2011 11:25:38 Null value DEFAULT
UATTEST06 06-May-2011 11:25:42 Null value DEFAULT
WATERMR1 06-May-2011 10:15:51 Null value DEFAULT

NOTE: Only display users who have expiration date set.
Back to top