Re: How to grant select on view to public
Date: 1996/06/11
Message-ID: <4pj1a1$dph_at_sjx-ixn6.ix.netcom.com>#1/1
In <31BCB89B.5632_at_itsi.disa.mil> Bob Yeh <yehr_at_itsi.disa.mil> writes:
>
>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
Bob,
Try this:
connect user1/user1password
grant select on t1 to user3 with grant option;
connect user2/user2password
grant select on t2 to user3 with grant option;
connect user3/user3password
grant select on v1 to public;
exit
Beware of any security implications in your environment.
Steve
804-262-6332
Received on Tue Jun 11 1996 - 00:00:00 CEST