开发者

TO find out any user using SQL on specific table

开发者 https://www.devze.com 2023-01-22 16:04 出处:网络
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 th

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

精彩评论

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