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: Granting roles from stored procedure

Re: Granting roles from stored procedure

From: Sunil Godithi <sunil_at_ameya.com>
Date: 1997/03/05
Message-ID: <331D0EEC.65E1@ameya.com>#1/1

Chris Halioris wrote:
>
> Actually the stored procedure runs with the privileges of the user that
> created the procedure. Hence, if the account you compiled the procedure
> in does not have the privilege to issue the grant you are issuing, that
> would be your problem.

Try Granting the Create Role to PROC_OWNER WITH ADMIN

Sunil

-- 
"If you want what you've never had, 
 you must be willing to do what you've never done."
Received on Wed Mar 05 1997 - 00:00:00 CST

Original text of this message

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