Re: How to grant select on view to public

Bob Yeh wrote:
>
> Hi,
>
> I have user1 owns table t1, user2 owns table t2. User1 grants select on t1
> to public and user2 grants select on t2 to public.
>
> User3 create a view v1 that joint user1.t1 and user2.t2. I get a error when
> user3 grant select on v1 to public.
>
> Is there a way to have public see the view v1 that was created by user3?
>
> Thanks. Bob

Sure,

When you grant select on user1's t1 to public do this with the grant option. Same applies for user2's t2.

Now create you view v1 as user3 and then grant select on v1 to public.

If you do not wish for public to have the grant option on t1 and t2, you can grant select on t1 and t2 to public as you first did and then grant select with the grant option to user3 alone.

This should work...(no more ORA-01720!)

Naresh Received on Mon Jun 10 1996 - 00:00:00 CEST