OraFAQ Forum: Security » Row has updated or deleted

Home » RDBMS Server » Security » Row has updated or deleted

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

Row has updated or deleted [message #152476]

Fri, 23 December 2005 07:32

sunil_mahajan26
Messages: 7
Registered: December 2005
Location: Gurgoan

Junior Member

I have one table upr which conains the information of user
like user_id,passwd and so on . This table is used by our application to authenticate the application user. I got one problem in it. Someone from sql has deleted the row for user 'abc' and now he is not able to login from application.
I wanna know which user had done that and at what time.

One method I already know is 'LOGMINER' Is there any other way thru which I can find out this

Help me
I am very thankful

Report message to a moderator

Re: Row has updated or deleted [message #152481 is a reply to message #152476]

Fri, 23 December 2005 07:51

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

If the AUDITING was enabled on that table then you can otherwise you cant.

But for future use you can enable auditing, look into manuals for Database Auditing.

Report message to a moderator

Re: Row has updated or deleted [message #152483 is a reply to message #152481]

Fri, 23 December 2005 07:57

sunil_mahajan26
Messages: 7
Registered: December 2005
Location: Gurgoan

Junior Member

Auditing was not enabled .
First If the audiditng is enabled then what is the procedurte to check it.

Secondly we r having views v$session and v$sqlarea can we not able to check thru these views

Regards
Sunil

Report message to a moderator

Re: Row has updated or deleted [message #152485 is a reply to message #152483]

Fri, 23 December 2005 08:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

@Sunil

Better to read the documentation related to Auditing , thats the best place to start off.
then depending on the auditing type;
TYPE Place to look into
OS level -- File name mentioned
DB level -- AUD$, and other related views

And i suppose V$session , V$SQL holds information regarding what is happening presently not what had happened earlier.

Report message to a moderator

Re: Row has updated or deleted [message #152488 is a reply to message #152485]

Fri, 23 December 2005 08:06

sunil_mahajan26
Messages: 7
Registered: December 2005
Location: Gurgoan

Junior Member

Thanks Tarun I will definitely read the documentation and then come back for further discussion

Report message to a moderator

Previous Topic:	authentication methods
Next Topic:	set Expiry Date of user password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 12:14:53 CDT 2023