Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between grant to user and grant to role
Hi Anker,
It's right, but I don't know why.
regards
Jerry
Anker Møller wrote:
>
> Hi,
>
> When I grant object priviliges to a user, the user can reference the object
> both in SQL and PL/SQL.
>
> When I grant object privliges to a role and grant the role to a user, the
> user can reference the object in SQL, but not in PL/SQL.
>
> Can it be right? and why?
>
> --
> Kind regards
> Anker Møller
> Tele Danmark Internet - Internal Systems
>
> E-mail work.. mailto:anmo_at_int.tele.dk
> Phone......... +45 89 37 62 86
> Fax.............. +45 86 78 38 00
--
Jerry Gitomer ICT Group jgitomer_at_ictgroup.com Langhorne PA jgitomer_at_yahoo.com Opinions are mine not those of ICT GroupReceived on Fri Jul 31 1998 - 07:41:54 CDT
![]() |
![]() |