I would like to make an Audit Table, but I do not want to send the information from the application I want it to be extracted from the Database, from the session ? what are the variables that I can extract friom session from example can I extract the PC Network name from the session.
Aiman H. Al-Jumoay
but sorry i am not sure
userenv or sys_context functions
"can I extract the PC Network name from the session"
Partly comes down to how the end user connects to the database. If there is something in between (eg an application server) all the database knows is that the connection is from the application server (plus anything the application server 'tells it', but obviously that is part of the application).
Click Here to Expand Forum to Full Width