I have faced an issue .
there are someone log in to the database and with sql statement through sqlplus he delete a record
I need a plan to implement an audit for this issue and a security method to apply to prevent this issues
and if it applicable how to create a database user like apps for the developer to recognize who is connecting the database
my environment :
DataBase : 11g R1(126.96.36.199)
applications : R 12.1.2
I will be so appreciated for helping me
Osama Mohamed ahmed
You can do it by Auditing the Database useing FGA(Fine Grained Auditing) and DBV(database vault) and for using those you need the licence for that.
however you can use some basic auditing
check the blow link for more deatail about the configuration.
Thanks HTH ,
But it is for oracle RDBMS 10g Release 2 and when I try to search in 11g Release 1 I couldn't find any audit section .
If it is any new audit tools please named it .
Thanks a lot and in advance
You can try to Implement on your database, it will Work on 11g Without issue.
if you are more interested what is new in 11g from 10g you can visit the link