Re: How to find out VAX/VMS username via SQL*Forms 3.0?
From: Roger Donahue <roger_at_monkeyboy.WPI.EDU>
Date: 7 Mar 1994 19:22:35 GMT
Message-ID: <2lfutr$l9d_at_bigboote.WPI.EDU>
Date: 7 Mar 1994 19:22:35 GMT
Message-ID: <2lfutr$l9d_at_bigboote.WPI.EDU>
Here's what I do to get the VMS username, using the performance monitoring views:
(V6)
select username from v$process where terminal = userenv('terminal');
(V7)
select osuser from v$session where audsid = userenv('sessionid');
Just make sure the users have select access to the views Received on Mon Mar 07 1994 - 20:22:35 CET