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: Grants for packages

Re: Grants for packages

From: Erik Oosterling <EOosterling_at_rikoos.demon.nl>
Date: Tue, 6 Oct 1998 11:12:37 +0200
Message-ID: <907664876.27645.0.spot.d4ee0d81@news.demon.nl>


Looks okay by me.

But if you use tables from a other shema in the package, you have to grant these table direct to the package owner !

VYA Maija-Leena Kangasmäki wrote in message <3619DEF0.BC8628FA_at_tieto.com>...
>I tried to grant execute privileges to packages through roles but it
>doesn't seem to work. Like this:
>Grant execute on package p1 to role1;
>grant role1 to user1;
>
>Isn't this possible ?
>
>Regards,
>
>Maija-Leena
>
Received on Tue Oct 06 1998 - 04:12:37 CDT

Original text of this message

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