Monitor user password change in oracle

jl66 used Ask the Experts™
Have a request for any ideas or links on how to write a trigger to monitor database user password change in Oracle 12c.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012
easiest way would be to simply add logging to the password verify function used in the user profiles.

if you don't have one, create one and add it to the default profile so everyone inherits it

the logging could be writing to a file via utl_file or writing to a table with inserts


Thanks a lot.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial