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

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 27 Apr 2004 08:53:32 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5B78@exchsen0a1ma>

Helmut,

You need to have the "select" priv granted directly to you. I'm guessing that you have access to this table thru a role.

Tom Mercadante
Oracle Certified Professional

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

From: Daiminger, Helmut [mailto:HELMUT.DAIMINGER_at_WWK.DE] Sent: Tuesday, April 27, 2004 8:46 AM
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


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

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

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:51:53 CDT