SYS_CONTEXT('USERENV','session_environment_var') should to the
trick. Look up this function in the SQL Reference and you will find
comprehensive list of variables provided in the USERENV context
space. SESSION_USER and CURRENT_USER may be of particular
interest - first is the user who initiated the session and second is
the user under whose privileges calling code executes.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Jan 14 2003 - 13:09:50 CST
