On one database with same password users perform DML commands from different terminals, how i can detect who perform update or delete and that entries are save in a table with terminal name and user ?
Thanx
Printable View
On one database with same password users perform DML commands from different terminals, how i can detect who perform update or delete and that entries are save in a table with terminal name and user ?
Thanx
Trigger on the table and select from v$session.machine or osuser.
I suppose you could use the auditing features to do this too.