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 Group