This content has been marked as final. Show 2 replies
Well, i did not used FGA yet.
I used audit_Trail=db and the query SELECT username,extended_timestamp,owner,obj_name,action_name,sql_text FROM dba_audit_trail WHERE to_char(extended_timestamp, 'DD/MM/RR') = to_char(SYSDATE - 1, 'DD/MM/RR') ORDER BY timestamp)
Then i wrote a procedure, and exported the results using utl_file .
And i scheduled this procedure to run daily.
It works pretty good, if you like the solution as ask for details.
Hope that helps,
Thanks for your suggestion but it's not exactly what I am looking for.
I have thought to create manual extraction jobs, but I want to limit the operations needed to have FGA records in the syslog as we have a lot of databases and this would make databases administration heavier.
So create manual extraction is indeed a solution but if the Database embed a way (initialization parameter, package, etc.) to do this, I would prefer to use this solution.