Re: What am I missing???

On Sun, 04 Mar 2001 14:27:44 GMT, "The Burkes" <jlburke_at_mediaone.net> wrote:

>I know the issue you are asking about.
>
>A user can only create views against a table that he has been granted rights
>to directly.
>
>for instance.
>
>UserA owns TableA.
>grant select on UserA.TableA to SomeRole;
>grant SomeRole to UserB
>
>UserB can do this:
>select * from UserA.TableA
>but can NOT do this:
>create view ViewB as select * from UserA.TableA
>
>If the privs are granted directly to UserB then the create view statement
>will work.
>

I believe if you grant with admin option, then the create view can be done.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Mon Mar 05 2001 - 05:20:54 CST