Home » RDBMS Server » Security » Logminer and password change (Oracle 10g)
Logminer and password change [message #479325] Fri, 15 October 2010 20:05 Go to next message
preet_kumar
Messages: 165
Registered: March 2007
Senior Member
Is it possible to track the password changes made by some user using the logminer with the archived logs?
Re: Logminer and password change [message #479326 is a reply to message #479325] Fri, 15 October 2010 21:04 Go to previous message
BlackSwan
Messages: 22780
Registered: January 2009
Senior Member
Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> desc user$
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 USER#					   NOT NULL NUMBER
 NAME					   NOT NULL VARCHAR2(30)
 TYPE#					   NOT NULL NUMBER
 PASSWORD					    VARCHAR2(30)
 DATATS#				   NOT NULL NUMBER
 TEMPTS#				   NOT NULL NUMBER
 CTIME					   NOT NULL DATE
 PTIME						    DATE
 EXPTIME					    DATE
 LTIME						    DATE
 RESOURCE$				   NOT NULL NUMBER
 AUDIT$ 					    VARCHAR2(38)
 DEFROLE				   NOT NULL NUMBER
 DEFGRP#					    NUMBER
 DEFGRP_SEQ#					    NUMBER
 ASTATUS				   NOT NULL NUMBER
 LCOUNT 				   NOT NULL NUMBER
 DEFSCHCLASS					    VARCHAR2(30)
 EXT_USERNAME					    VARCHAR2(4000)
 SPARE1 					    NUMBER
 SPARE2 					    NUMBER
 SPARE3 					    NUMBER
 SPARE4 					    VARCHAR2(1000)
 SPARE5 					    VARCHAR2(1000)
 SPARE6 					    DATE

PTIME was when password was last changed
Previous Topic: SSL, WebAPPs and database
Next Topic: PL SQL Compilation Session
Goto Forum:
  


Current Time: Tue Sep 16 07:00:55 CDT 2014

Total time taken to generate the page: 0.09657 seconds