OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Table data changed (Oracle 11gr2,Linux 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table data changed [message #605369]

Wed, 08 January 2014 23:13

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.

Report message to a moderator

Re: Table data changed [message #605370 is a reply to message #605369]

Wed, 08 January 2014 23:28

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.

Report message to a moderator

Re: Table data changed [message #605374 is a reply to message #605370]

Wed, 08 January 2014 23:57

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

Report message to a moderator

Re: Table data changed [message #605382 is a reply to message #605369]

Thu, 09 January 2014 01:02

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Table data changed [message #605448 is a reply to message #605369]

Thu, 09 January 2014 08:20

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.

Report message to a moderator

Previous Topic:	space recovery
Next Topic:	Database connectivity check

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 21:33:40 CST 2024