Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Views and Roles
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