开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜