Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Difference between grant to user and grant to role
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 00Received on Fri Jul 31 1998 - 06:55:02 CDT
![]() |
![]() |