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 -> Difference between grant to user and grant to role

Difference between grant to user and grant to role

From: Anker Møller <anmo_at_int.tele.dk>
Date: Fri, 31 Jul 1998 13:55:02 +0200
Message-ID: <6psbbf$lf0$1@news-inn.inet.tele.dk>


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


Received on Fri Jul 31 1998 - 06:55:02 CDT

Original text of this message

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