Re: View on a table of another user

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/29
Message-ID: <IivY4.215592$Tn4.1935855@news1.rdc2.pa.home.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.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message
news:8gqsem$jt$11$1_at_news.t-online.com...


> > This should work.

> > Without more exact error messages other than 'It doesn't work' the ng

 will


> > not be able to resolve your problem.

> > Please post exact error messages.

>

>

> The error message is

>

> ORA-00942: Tabelle oder View nicht vorhanden

>

> First I granted all priviliges to a role. Now I tried to grant all

> privileges to the user. But it do not work either.

>

> The thing with the * I only used for testing.

>

> Regards

> Nicolas

>

>

Received on Mon May 29 2000 - 00:00:00 CDT