Today I'll share with you one of my scripts I'm using to easily retrieve the audit records of an oracle database user.
DISCLAIMER: THIS SCRIPT IS DISTRIBUTED IN THE HOPE THAT IT WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. IT IS PROVIDED "AS IS".
Note: Auditing should be enabled on the database or the script will return no rows.
To enable auditing please check this article:
http://www.oracle-base.com/articles/10g/auditing-10gr2.php
To enable auditing please check this article:
http://www.oracle-base.com/articles/10g/auditing-10gr2.php
Download the script from this link:
Once you run this script it will let you choose the database you want to retrieve data from (in case that you have multiple running databases on the server), then it will ask you to enter the username, and lastly will ask you to enter the number of days back you want to retrieve audit data or enter a specific date.
This script is very easy to use, it has been tested on Linux and SUN environments.
DISCLAIMER: THIS SCRIPT IS DISTRIBUTED IN THE HOPE THAT IT WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. IT IS PROVIDED "AS IS".
Here is the script code, in case the download link is not working with you:
Scripts is not available
ReplyDeleteScripts not available on provided link
ReplyDeleteDear Md. Tanweer,
ReplyDeleteThanks a lot for your comment.
I've updated the links to a good working ones.
Thanks again and sorry for any inconvenience caused.
Mahmmoud ADEL