3

I want to record how many times or which user accounts passwords were changed using Oracle database auditing techniques. I also want to record any password changes done to system user account.

3
  • I suggest you read the documentation. docs.oracle.com/cd/E11882_01/server.112/e10575/…
    – Philᵀᴹ
    Commented May 22, 2017 at 10:22
  • Followed the document and set audit_trail parameter to DB_EXTENDED, Commented May 23, 2017 at 7:47
  • Then created a test user, connected to that user and tried to change password of that user. I could not find any entry in DBA_AUDIT_TRAIL. Commented May 23, 2017 at 8:02

1 Answer 1

1

Auditing can capture when a user changes their own password. If a sys or admin user changes the password of another user that can't be captured in auditing.

You can use this metalink doc (ID 419942.1) to create a system trigger and change it to add an entry in a temp table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.