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
Use sys_context in a database trigger to capture ip_address.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g DBA
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
Click Here to Expand Forum to Full Width