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