Re: Difference between grant to user and grant to role

From: <bhogak_at_my-dejanews.com>
Date: Sat, 01 Aug 1998 03:35:53 GMT
Message-ID: <6pu2eq$hp5$1@nnrp1.dejanews.com>

Hi!
Usually roles work fine except in cases of stored procedures(and also for view,FKs etc). When you are referencing any object inside a function/proc you have to explicitly grant priv to that object. Real pain?? Thanks.
-Kumar
In article <6psbbf$lf0$1_at_news-inn.inet.tele.dk>, "Anker Møller" <anmo_at_int.tele.dk.x> 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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 31 1998 - 22:35:53 CDT