Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Phantom deletes
nbindal_at_my-dejanews.com wrote:
> <SNIP>
> To debug this problem we added a trigger (BEFORE DELETE) on this table, to log
> into another dummy table the row that is getting deleted. Is there any way to
> put in this trigger the processid of the client program which is deleting -
> that way we identify the source of problem. Also if anyone has other ideas of
> finding the culprit, it would be very helpful.
>
Assuming the application is not doing a login/logout and then login as schema owner(which peoplesoft i know for sure does, what a pain in the a$$), you can use the pseudo column user to see who is doing the deleting.
hth, joe
--
Joseph S. Testa, Oracle Database Administrator
Vice-President Ohio Oracle Users Group, http://www.ooug.org
OOUG welcomes Steven Feuerstein to Columbus OH in Oct, if your company is
interested in becoming a corporate sponsor for this event, send
mailto:vice_pres_at_ooug.org.
Want some remote DBA work done? mailto:teci_at_oracle-dba.com
ICQ http://wwp.mirabilis.com/2832230
Received on Mon May 18 1998 - 17:57:41 CDT
![]() |
![]() |