Re: Views and Roles

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 26 Jun 2001 20:46:20 -0700
Message-ID: <3B39570C.44941A17@exesolutions.com>

Rob K wrote:

> Is there any way a user can create a view on tables residing in another
> schema without having to grant explicit select rights to the tables? I would
> like to use roles but Oracle will not let the user create the view based on
> those tables.
>
> Thanks Rob

No. To create a view you must have SELECT granted on the object.

Why not assign the grant to the role rather than to the user?

Daniel A. Morgan Received on Tue Jun 26 2001 - 22:46:20 CDT