开发者

Retrieving Username Using Oracle Triggers

开发者 https://www.devze.com 2023-02-12 21:14 出处:网络
I am new to using triggers. What function can I use to determine who tripped my trigger? For example:开发者_如何转开发

I am new to using triggers. What function can I use to determine who tripped my trigger?

For example:开发者_如何转开发

Someone updates a row, and I want to know who updated the row.

I am using Oracle 10g.


SELECT sys_context('USERENV', 'SESSION_USER') FROM dual;

or

SELECT sys_context('USERENV', 'SESSION_USERID') FROM dual;
0

精彩评论

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