Just one FYI that has come up for me recently. The RESOURCE role provides a lot of basic grants, such as CREATE TABLE and CREATE TRIGGER. However it does NOT include CREATE VIEW. Just an FYI if you were depending on this for a basic set of user privileges. Don. On Feb 16, 2008 8:22 AM, Baumgartel, Paul <paul.baumgartel@xxxxxxxxxxxxxxxxx> wrote: > 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@xxxxxxxxxxxxxxxxx > www.credit-suisse.com > > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of > genegurevich@xxxxxxxxxxxx > Sent: Friday, February 15, 2008 6:07 PM > To: oracle-l@xxxxxxxxxxxxx > 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 > > > -- > //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 > ============================================================================== > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l