I would like to know how we can have a trace on table to findout which
IP address and port are updating the table.

Regards,
Giri

GiriBabu.09 (AT) gmail (DOT) com wrote in news:1179742335.836698.58760
@n15g2000prd.googlegroups.com:

Not easily

GiriBabu.09 (AT) gmail (DOT) com wrote:
Ports ... not sure it is possible or that it has any meaning. Is the
connection coming through an application server to the listener?

IP address can be determined using SYS_CONTEXT function
http://www.psoug.org/reference/sys_context.html

Table update can be found using BEFORE or AFTER update trigger
http://www.psoug.org/reference/table_trigger.html
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On May 21, 5:12 am, GiriBabu... (AT) gmail (DOT) com wrote:
Why?

I suppose you could write your own version of sqlplus in C++/OCCI
which would glean all of this information (including the MAC address,
system time and current operating system version as well as the IP
address and port) from the client PC for you and send it off to a set
of 'hidden' tables, install that on every client machine and have the
users invoke that for all of their database work. You could call it
"sqlplusbb", the 'bb' being 'Big Brother'.

Of course connection auditing is an option, in conjunction with object
auditing via a trigger as Daniel has already stated.

I ask again why you think you 'need' this information.


David Fitzjarrell