Topic
  • 1 reply
  • Latest Post - ‏2012-06-23T05:50:18Z by mohkawa
mohkawa
mohkawa
9 Posts

Pinned topic VIEW is not generated properly in some environment

‏2012-06-18T02:33:02Z |
In some environment, all views are generated like the following.

CREATE OR REPLACE VIEW "SCHEMA1"."V1"
("SCHEMA1", "SCHEMA1", "SCHEMA1", ...)
AS
SELECT ...

As shown above, all column names are the view's schema name.
Therefore, issuing it causes the following error.

SQL0612N "SCHEMA1" is a duplicate name.

The user used in the IDMT has SELECT_CATALOG_ROLE privilege.
But still the following SQL issued by IDMT causes the following error.

SELECT MAX(DBMS_LOB.GETLENGTH("PASSWORD")) FROM "SINGLESM"."BIN$tKhDCiSNVIzgRAAhKKX/0A=$0"

ORA-01031 Insufficient privilege
Updated on 2012-06-23T05:50:18Z at 2012-06-23T05:50:18Z by mohkawa
  • mohkawa
    mohkawa
    9 Posts

    Re: VIEW is not generated properly in some environment

    ‏2012-06-23T05:50:18Z  
    I found out that the customer revoked SELECT_CATALOG_ROLE privilege.
    Granting SELECT_CATALOG_ROLE solved this problem.