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