Re: Trigger variables

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Thu, 06 Dec 2001 04:43:42 GMT
Message-ID: <2ICP7.50923$xS6.84271@www.newsranger.com>

[...]
>I would like to be able to grab information like OSUSER from v$session
>on the individual who causes the trigger to fire.
>

[...]

Hi,
as always you forgot to mention what oracle release are you using.

If 8i so try do next:
SELECT SYS_CONTEXT('USERENV', 'OS_USER') FROM DUAL; Operating system username of the client process that initiated the database session. For more attributes see the description of SYS_CONTEXT function.

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

Received on Wed Dec 05 2001 - 22:43:42 CST