RE: Why does this "create view" statement fail?
- From: "Hitchman, Peter" <Peter.Hitchman@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Apr 2004 13:55:39 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daiminger, Helmut
Sent: 27 April 2004 13:46
To: 'LazyDBA.com Discussion'; 'oracle-l@xxxxxxxxxxxxx'
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)
-------------
3
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
