Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SET ROLE in PL/SQL

SET ROLE in PL/SQL

From: Jerry Apfelbaum <japfelba_at_ican.ca>
Date: 1997/12/09
Message-ID: <348E120A.DA60AC75@nospamican.ca>#1/1

We have not had any success with trying to execute the SQL command:

          SET ROLE ThisRole IDENTIFIED BY ThisPassword; using dynamic SQL in either an anonymous PL/SQL block or in a stored procedure.

Can this be done? If not, is there an explanation as to why this is not permitted?

--
========================================================
Jerry Apfelbaum
Eastern Sun Group Inc.
Toronto, Canada
------------------------------------------------------------------------

(Due to proliferation of spammers, remove 'nospam' my email address.)
Received on Tue Dec 09 1997 - 00:00:00 CST

Original text of this message

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