Home » RDBMS Server » Server Administration » Table data changed (Oracle 11gr2,Linux 6)
Table data changed [message #605369] Wed, 08 January 2014 23:13 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

Client found somebody has modified the table data and wants to know who has did it and for what purpose it was done.Could you tell me how to find out that ?

Thanks.
Re: Table data changed [message #605370 is a reply to message #605369] Wed, 08 January 2014 23:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Client found somebody has modified the table data and wants to know who has did it
is application 3-tier?

>and for what purpose it was done
do a Vulcan mind meld after you determine the culprit or just ask him.
Re: Table data changed [message #605374 is a reply to message #605370] Wed, 08 January 2014 23:57 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Blackswan,

Quote:
is application 3-tier?

How to find out that ?

Quote:
do a Vulcan mind meld after you determine the culprit or just ask him.

i didn't understand this. could you elaborate ?

Thanks
Re: Table data changed [message #605382 is a reply to message #605369] Thu, 09 January 2014 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you want to know who, you have to activate audit.
Now you have to mine the logs.
Both are described in the documentation you have been pointed to in each of your topic.

Re: Table data changed [message #605448 is a reply to message #605369] Thu, 09 January 2014 08:20 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Jack14 wrote on Thu, 09 January 2014 00:13
... and for what purpose it was done.


Do you realize the silliness of this question? Just think about it.
Previous Topic: space recovery
Next Topic: Database connectivity check
Goto Forum:
  


Current Time: Thu Mar 28 15:33:51 CDT 2024