RE: Why does this "create view" statement fail?

From: Hitchman, Peter <Peter.Hitchman_at_thomson.com>
Date: Tue, 27 Apr 2004 13:55:39 +0100
Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E02DAAE@der-lon-msg-03.derwent.co.uk>

Hi,
The schema dwhdata needs to grant the select privilege directly to the schema L2930, for L2930 to be able to create the view.

Regards

Pete

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daiminger, Helmut Sent: 27 April 2004 13:46
To: 'LazyDBA.com Discussion'; 'oracle-l_at_freelists.org' Subject: Why does this "create view" statement fail?

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

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

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

Received on Tue Apr 27 2004 - 07:56:01 CDT