RE: insufficient privileges
Date: Sat, 16 Feb 2008 09:22:31 -0500
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?
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Friday, February 15, 2008 6:07 PM
Subject: insufficient privileges
I have a script that creates a view. The script is failing with
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?
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.freelists.org/webpage/oracle-l Received on Sat Feb 16 2008 - 08:22:31 CST