Home » Other » General » Looking for software to track DML operations - auditing, controlling (Oracle 10g)
Looking for software to track DML operations - auditing, controlling [message #628427] Tue, 25 November 2014 03:58 Go to next message
spsbombay
Messages: 29
Registered: June 2007
Junior Member

Hello All,

we are supporting a number of applications hosting on multiple databases. we are facing significant challenge in controlling DML/Operational changes done by various support members into client facing applications.
As of now, team members are running DML statements directly into database which is difficult to track.

We are exploring options to use any freeware software where we can:
- Submit the script we want to execute
- different approval workflow based on application/teams
- auditing of number of records impacted
- alarming/restricting DML's in case of unusual behaviour
- link the changes to users who are performing it.


I tried to search in google but could not find any suitable software app.

Could you please help if you are aware of any or using.

Thanks for your support.

Regards,
Prashant Sharma

Re: Looking for software to track DML operations - auditing, controlling [message #628472 is a reply to message #628427] Tue, 25 November 2014 09:20 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You have a procedural problem which is not best solved by technology.
Change their passwords so they can not do DML on Production databases.
Either they are professional & responsible, or they can't be trusted.
Previous Topic: Into the DB or outside it : here is the question !
Next Topic: Unique patch ID: - opatch
Goto Forum:
  


Current Time: Mon Dec 05 07:28:16 CST 2022