Home » SQL & PL/SQL » SQL & PL/SQL » Audit on password change
Audit on password change [message #204316] Mon, 20 November 2006 02:26 Go to next message
svik
Messages: 16
Registered: April 2005
Location: MRU
Junior Member
Hi to all,

I want to know how to know the details on password change? i mean the user, date/time etc who change the password for user sysoper? database version is 7.1.6.2.0

Thanks
Re: Audit on password change [message #204319 is a reply to message #204316] Mon, 20 November 2006 02:45 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
On a less antediluvian version of Oracle, you could enable Auditing.

You might (I don't know if this functionality is availble in your release) be able to (ab)use the Password Complexity Verification function and add code to that to log who was attempting to change a password.
Re: Audit on password change [message #204329 is a reply to message #204319] Mon, 20 November 2006 03:25 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I really doubt if you will get away with that. No autonomous transaction remember.
But it is worth a try... After all, if you're still on 7.1.6, you don't really care about your database anyway.
Re: Audit on password change [message #204338 is a reply to message #204329] Mon, 20 November 2006 03:47 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You could use DBMS_PIPE and another session listening on the far end - the poor mans autonomous transaction....

I wonder if the OP meant 8.1.6.2.0

Actually - looking on Google 7.1.6.2.0 was a production release, so perhaps the really are still using it.

Scary.
Previous Topic: Query Help
Next Topic: Table Partition
Goto Forum:
  


Current Time: Fri Dec 02 17:00:58 CST 2016

Total time taken to generate the page: 0.32509 seconds