Auditing only SQL Developer commands

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Auditing only SQL Developer commands

VinodN
Hello Erman! We have some custom applications which have schemas in our EBS database. Some admins in the custom applications have access to the APPS schema and I want to audit their actions. They connect via SQL Developer. I want to know whether it is possible to audit their activity which they do via SQL Developer. I tried to enable audit on DML, DDL by APPS but it is auditing so many unimportant actions and causing performance issues.
Our EBS is 12.2.10 and database is 19.27
Reply | Threaded
Open this post in threaded view
|

Re: Auditing only SQL Developer commands

ErmanArslansOracleBlog
Administrator
You can do that by using "AUDIT POLICY" but still, it can be bypassed by renaming the executable on the client side.