Can I get logged in user name from within a stored procedure?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sun, 29 Aug 1999 16:00:46 GMT
Message-ID: <37c958b8.1084779@netnews.worldnet.att.net>

Does anyone know a good way to get the name of the currently logged in user from within a stored procedure? The USER function always returns the name of the procedure's creator. Is there a way around this? I'm using Oracle8, not 8i.

Jonathan

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Sun Aug 29 1999 - 11:00:46 CDT

This message: [ Message body ]
Next message: prakbala_at_hotmail.com: "UTL_FILE code example"
Previous message: KC: "Move a object to another data file of the same tablespace"
Next in thread: David Sisk: "Re: Can I get logged in user name from within a stored procedure?"
Reply: David Sisk: "Re: Can I get logged in user name from within a stored procedure?"
Reply: fumi: "Re: Can I get logged in user name from within a stored procedure?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US