Re: CREATE OR REPLACE VIEW ORA-01031

Terry Dykstra wrote:

> "Marcin Wr=EF=BF=BDblewski" <m_wroblewski@[EMAIL PROTECTED]
> wrote in message
> news:g4gasn$fih$1@[EMAIL PROTECTED]
> > max.fontain@[EMAIL PROTECTED]
 pisze:
> >> Hello,
> >> I am trying to run a long sql script that creates tables, triggers
and
> >> procedures etc.
> >> I ran the same script on 9i some time ago and it worked OK - but 10G
> >> barfs on  CREATE OR REPLACE VIEW as follows:
> >>
> >> DROP USER getre****ts CASCADE;
> >>
> >> CREATE USER getre****ts IDENTIFIED BY getre****ts
> >> DEFAULT TABLESPACE getre****ts
> >> TEM****ARY TABLESPACE getre****ts_TEMP
> >> PROFILE DEFAULT ACCOUNT UNLOCK;
> >> GRANT CONNECT TO getre****ts;
> >> GRANT RESOURCE TO getre****ts;
> >> GRANT SELECT_CATALOG_ROLE TO getre****ts;
> >> GRANT SELECT ANY TABLE TO getre****ts;
> >> GRANT UNLIMITED TABLESPACE TO getre****ts;
> >>
> >> CONNECT getre****ts/getre****ts
> >>
> >> SQL> CREATE OR REPLACE VIEW REFERENCE_DATE AS
> >>   2  SELECT sysdate Ref_Date FROM dual;
> >> CREATE OR REPLACE VIEW REFERENCE_DATE AS
> >>                        *
> >> ERROR at line 1:
> >> ORA-01031: insufficient privileges
> >>
> >> I suppose that some additional privileges for the getre****ts user are
> >> required.
> >> Could someone help me out here?
> >>
> >> TIA
> >>
> >> Max
> >
> > GRANT CREATE VIEW TO GETRE****TS
> > /
> >
> > ?
>
> Take a look at the CONNECT privileges in 10g.  Oracle cleaned it up and
n=
ow
> it has nothing more than create session.
> Grant select any table and unlimited tablespace should be handled with
ca=
re.
> Allways go by least required privileges.
>
> --
> Terry Dykstra
Thanks for your responses - sorted now!