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

Home -> Community -> Usenet -> c.d.o.server -> Re: Set Role From a Stored Procedure

Re: Set Role From a Stored Procedure

From: Peter H. Larsen <plen_at_novo.dk>
Date: 1997/06/27
Message-ID: <33B37D1D.FE63EF92@novo.dk>#1/1

Hi,
Roles are disabled within stored procedures (views, procedure, function, package, trigger). The SET ROLE then doesn't have any valid purpose and cannot be used.

Bob England wrote:

> Is anyone familiar with a way to issue a Set Role from within a stored
>
> procedure? Thanks.
Received on Fri Jun 27 1997 - 00:00:00 CDT

Original text of this message

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