Re: Views and Roles

From: Rob K <robkato_at_earthlink.net>
Date: Wed, 27 Jun 2001 13:52:26 GMT
Message-ID: <uyl_6.741$ef.108272@newsread2.prod.itd.earthlink.net>

Daniel,
I'm not sure what you mean.

I have a schema dwp1 that has all the tables. I create a role that has select access to the tables. I grant the role to user cars_mart.
The user cars_mart cannot create a view using the tables via the role. I have to grant select option for each table to cars_mart.

Thanks Rob
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B39570C.44941A17_at_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 Wed Jun 27 2001 - 08:52:26 CDT