In some environment, all views are generated like the following.
CREATE OR REPLACE VIEW "SCHEMA1"."V1"
("SCHEMA1", "SCHEMA1", "SCHEMA1", ...)
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
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-06-23T05:50:18Z by mohkawa
Pinned topic VIEW is not generated properly in some environment
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-23T05:50:18Z at 2012-06-23T05:50:18Z by mohkawa