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

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 31 Aug 1999 14:01:52 GMT
Message-ID: <7qgn8g$aos$2@news.seed.net.tw>

Jonathan Gennick <jonathan_at_gennick.com> wrote in message news:37c958b8.1084779_at_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

The USER function in a procedure will return the current user, not the owner of the procedure. Received on Tue Aug 31 1999 - 09:01:52 CDT

This message: [ Message body ]
Next message: Patrick Drouin: "Database level Authentication from OAS"
Previous message: Tapan Trivedi: "Removing the Archived logs question"
In reply to: Jonathan Gennick: "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