Why does this "create view" statement fail?

From: Daiminger, Helmut <HELMUT.DAIMINGER_at_WWK.DE>
Date: Tue, 27 Apr 2004 14:45:33 +0200
Message-ID: <706FB6D452A69442B8275372F22C19150367E568@serv102.wwk.de>

Hi!

I am experiencing something weird here... I am the user L2930 (with DBA role).

When I issue a select statement to select data from another user's table, it works fine:

SQL> select count(beadat) from dwhdata.b3000t; COUNT(BEADAT)

Now I want to put that exact select statement in a view:

SQL> create view testview as select beadat from dwhdata.b3000t with read only;
create view test as select beadat from dwhdata.b3000t with read only

ERROR at line 1:
ORA-01031: insufficient privileges

That doesn't make much sense to me... Any ideas?

This is 9.2 on HP-UX 11i.

Thanks,
Helmut

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Apr 27 2004 - 07:44:15 CDT