Re: determining OPS$ username in Forms

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.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.