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

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
    ACCEPTED ANSWER

    Re: VIEW is not generated properly in some environment

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