Connect as a different user in PL/SQL

From: Bartolo, David <bartolo_at_USCOLO.edu>
Date: Tue, 21 Aug 2001 14:18:22 -0700
Message-ID: <F001.00373357.20010821143554@fatcity.com>

Hi all,

Is there a way to connect or see if a username and password are valid in a PL/SQL procedure?
I will come in as one user. Pass in the username and password I want to validate. Try to connect to the
database with that username and password.

Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bartolo, David
  INET: bartolo_at_USCOLO.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 21 2001 - 16:18:22 CDT