Re: insufficient privileges

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_at_credit-suisse.com> 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_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
>
>
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l