RE: insufficient privileges
Date: Sat, 16 Feb 2008 09:22:31 -0500
Message-ID: <21469B88E0EA11498818517F2103353101C65F2C@EPRI17P32001A.csfb.cs-group.com>
Gene,
You'll need to supply more details.
Does the creator of the view have CREATE VIEW privilege?
If yes, does the creator of the view also own the tables, or are they in another schema?
If another schema, are privileges granted directly or via a role?
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
genegurevich_at_discover.com
Sent: Friday, February 15, 2008 6:07 PM
To: oracle-l_at_freelists.org
Subject: insufficient privileges
Hi everybody:
I have a script that creates a view. The script is failing with
ORA-01031:
insufficient privileges. When I
execute the underlying select it works with no issue. I am unclear on
how
could this be and what could
be the reason for this. Does anyone have an explanation?
thank you
Gene Gurevich
--
http://www.freelists.org/webpage/oracle-l
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 16 2008 - 08:22:31 CST