Why does this "create view " statement fail? 2004-04-27 - By Hitchman, Peter
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Daiminger, Helmut
Sent: 27 April 2004 13:46
To: 'LazyDBA.com Discussion '; 'oracle-l@(protected) '
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 (See ORA-01031.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
