Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grants for packages
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
![]() |
![]() |