Information Related to Passwords and Auditing

V$PWFile_Users Information

User Name SYSDBA Privs SYSOPER Privs (Y/N)
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
DIP 22-Feb-2011 04:43:33 Null value DEFAULT
DP_ADM 04-Apr-2011 07:22:07 Null value DEFAULT
EDWARDN1 01-Jun-2011 14:33:33 Null value DEFAULT
JOSEPHJI 19-May-2011 16:30:07 Null value DEFAULT
ORACLE_OCM 22-Feb-2011 04:49:12 Null value DEFAULT
TEST1 19-May-2011 16:30:07 Null value DEFAULT
TSMSYS 22-Feb-2011 04:47:47 Null value DEFAULT
UATTEST01 19-May-2011 16:30:07 Null value DEFAULT
UATTEST02 19-May-2011 16:30:07 Null value DEFAULT
UATTEST03 19-May-2011 16:30:07 Null value DEFAULT
UATTEST04 19-May-2011 16:30:07 Null value DEFAULT
UATTEST05 19-May-2011 16:30:07 Null value DEFAULT
UATTEST06 19-May-2011 16:30:07 Null value DEFAULT

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