security issue

Hi,

Is there a way to capture information about the user's IP Address
who access (DML) a databse table? Especially when it is on a 3-tier
set-up?(web based client -> Apps server -> DB server)

Thsnk you all

U can know the m/c name from where the SQL is coming.
table v$session ,column is machine

regards
anandkl

Use sys_context in a database trigger to capture ip_address.

thanks friends,

is sys_context found in v$session?

does ure end user pc connect directly to the db, otherwise all you will get is the ip address of the app server