Re: determining OPS$ username in Forms

On Tue, 31 Aug 1999 13:58:08 GMT, markp7832_at_my-deja.com wrote:

  I use the example stated here with no problems.

  I use the following in my WHEN_NEW_FORM_INSTANCE trigger:

                select user into :boilerplate.userid from dual;

>In article <1761dd4a.ebff501d_at_usw-ex0107-050.remarq.com>,
> Gary <gary.perkinsNOmzSPAM_at_nt.gov.au> wrote:
>> Howdy, Is there a way to get around the problem of
>> GET_APPLICATION_PROPERTY(USERNAME) only returning a null
>> for OPS$ accounts?? Something like SQLPlus' show user would
>> be just dandy.
>>
>> Cheers
>> GP
>>
>> * Sent from RemarQ http://www.remarq.com The Internet's Discussion
>Network *
>> The fastest and easiest way to search and participate in Usenet -
>Free!
>>
>I do not develop in forms, but try the following:
>Use the psuedo column user:
> select user into :form_username from sys.dual;
>
>I suspect that will work since it works for OS authenticated sessions
>on our system. If that fails you can try:
>
>select se.osuser
>from v$session se
>where se.audsid = userenv('SESSIONID');
>
>I hope this helps.
Received on Thu Sep 02 1999 - 16:51:10 CEST