Track and maintain data changes for analysis and back tracking
From: nilesh kumar <nileshkum_at_gmail.com>
Date: Tue, 1 Nov 2022 11:55:13 +0530
Message-ID: <CACzEWSXC2u4VuAU3sf82YPT6UFTLUXoJr2WWbG1rRwY0u2G-yg_at_mail.gmail.com>
Dear All,
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown -- http://www.freelists.org/webpage/oracle-l Received on Tue Nov 01 2022 - 07:25:13 CET
Date: Tue, 1 Nov 2022 11:55:13 +0530
Message-ID: <CACzEWSXC2u4VuAU3sf82YPT6UFTLUXoJr2WWbG1rRwY0u2G-yg_at_mail.gmail.com>
Dear All,
Good Morning!
We have a special requirement from one of the application folks. 1. They would like to track the database changes, who did what changes and when in the database via the application interface. 2. They would like to document the individual steps that were executed for the data changes, its main purpose is for analysis and back tracking.
I had suggested a change management approach which would have a separated database and any changes in the database will be tracked via the change ticket, but the solution does not seem to be feasible to application owners.
Actually they are building a new system and process in place.
Any suggestions on this would be a great help.
-- Thanks & Regards Nilesh Oracle DBA (sqlplus "/as sysdba" is my world)
"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown -- http://www.freelists.org/webpage/oracle-l Received on Tue Nov 01 2022 - 07:25:13 CET