selecting osuser info inside a stored proc

Hi gang,

  I am writing a pl/sql stored procedure. Inside the procedure I want to determine the osuser who is executing the stored proc. The user will NOT have dba privileges, i.e. this will be a NORMAL user. Any ideas, hints,...

  I was thinking about creating another stored function owner by a dba that would return the osusers from v$session when called (execute priv would be granted to the NORMAL user). The problem is that this view (v$session) will return all users logged in.

 Thanks,
Clueless Received on Wed May 08 2002 - 08:19:39 CDT