Re: View on a table of another user

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: 2000/06/03
Message-ID: <8hb3k9$v7k$18$3@news.t-online.com>#1/1

> I can't remember the origional question (sql), but again it should work.
>
> as user bobf;
> SQLWKS> create table bob (a number, b varchar2(21));
> Statement processed.
> SQLWKS> grant select on bob to scott;
> Statement processed.
> SQLWKS> connect scott
> Connected.
> SQLWKS> create or replace view bob_vw as select * from bobf.bob;
> Statement processed.
>

Meanwhile I checked it. And it works. Thanks

Regards
Nicolas Received on Sat Jun 03 2000 - 00:00:00 CDT