Re: SET ROLE in PL/SQL

From: Blinoff Dmitry <moprok_at_ropnet.ru>
Date: 1997/12/11
Message-ID: <01bd061a$3f381bc0$0300a8c0@nata.moprok.ropnet.ru>#1/1

Jerry Apfelbaum <japfelba_at_ican.ca> çàïèñàíî â ñòàòüþ <348E120A.DA60AC75_at_nospamican.ca>...
> 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?

Check DBMS_SESSION package.
Where will be something ...

Dmitry, moprok_at_ropnet.ru Received on Thu Dec 11 1997 - 00:00:00 CST