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 -> Re: SET ROLE in PL/SQL

Re: SET ROLE in PL/SQL

From: Nathan D. Hughes <nhughes_at_well.com>
Date: 1997/12/12
Message-ID: <66s246$od4$1@was.hooked.net>#1/1

raymond allo <raymond_at_ramavista.com> writes:

>Jerry Apfelbaum wrote:
>>
>> 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.

 [...]
>I had the same problem and contacted Oracle about it. It doesn't work
>unfortunately. i have put in a change/enhancement request though. But
>for the mean time it is a no brainer.

What's wrong with dbms_session.set_role?

In SQL*Plus, "exec dbms_session.set_role('foo identified by bar');"

Works Great!

--

Nathan D. Hughes <nhughes_at_well.com>
Computer Consultants of America, Inc.
Received on Fri Dec 12 1997 - 00:00:00 CST

Original text of this message

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