Re: insufficient privileges
- From: "Don Seiler" <don@xxxxxxxxx>
- To: paul.baumgartel@xxxxxxxxxxxxxxxxx
- Date: Mon, 18 Feb 2008 09:49:11 -0600
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
Other related posts:
