TO find out any user using SQL on specific table
I'm working as an user. I want to know if the other u开发者_StackOverflowser making any INSERT, UPDATE, DELETE on any specific table. How to find out ? is there any SQL to do so ?
Make a trigger on the table and write the username into a log table.
In oracle you'd get the user from sys_context('USERENV', 'CURRENT_USER');
Other db's have similar functionality.
精彩评论