I want to write a select statement in a database table trigger to see who is deleting a record (User, PC name, program). V$session provides the info but I do not know how to identify the session that is deleting. Please help.
Oracle 8.0.5 on NT Server
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!