Re: Oracle 8: grant execute to ROLE

From: Michael S. Abbey <masint_at_istar.ca>
Date: 1998/03/22
Message-ID: <35149c2b.28269849@news.istar.ca>#1/1

On Sat, 21 Mar 1998 19:55:38 -0500, Tim Romano <tim_at_ot.com> wrote:

>Oracle 7 does not allow one to grant execute on a
>function to a ROLE; rather the grant has to be made for
>each user; is Oracle 8 any different in this respect?

I am not aware of this limitation in Oracle7. The problem most of us run into with roles is granting execute on a stored object that references stuff with privileges granted to roles rather than users. There is nothing keeping you from granting privileges on stored objects to functions.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Sun Mar 22 1998 - 00:00:00 CST