Re: CREATE OR REPLACE VIEW ORA-01031

max.fontain_at_yahoo.com 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 getreports CASCADE;
>
> CREATE USER getreports IDENTIFIED BY getreports
> DEFAULT TABLESPACE getreports
> TEMPORARY TABLESPACE getreports_TEMP
> PROFILE DEFAULT ACCOUNT UNLOCK;
> GRANT CONNECT TO getreports;
> GRANT RESOURCE TO getreports;
> GRANT SELECT_CATALOG_ROLE TO getreports;
> GRANT SELECT ANY TABLE TO getreports;
> GRANT UNLIMITED TABLESPACE TO getreports;
>
> CONNECT getreports/getreports
>
> 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 getreports user are
> required.
> Could someone help me out here?
>
> TIA
>
> Max

GRANT CREATE VIEW TO GETREPORTS
/

? Received on Wed Jul 02 2008 - 11:38:50 CDT