适用范围

11g+

问题概述

创建视图时，出现报错,ORA-01031: insufficient privileges

CREATE OR REPLACE FORCE EDITIONABLE VIEW "NEWRISK"."V_REPORT_INDUSTRY_INFO_2021" 
("SECURITY_ID", "SYMBOL_ID", "SYMBOL_CODE", "EXCH_TYPE_D", "SYMBOL_TYPE_D", "INDUSTRY_D", "INDUSTRY_NAME", "BEGIN_DATE", "END_DATE", "LEVEL_CODE", "LEVEL_NAME") AS 
SELECT SECURITY_ID,
       SYMBOL_ID,
       SYMBOL_CODE,
       EXCH_TYPE_D,
       SYMBOL_TYPE_D,
       INDUSTRY_D,
       INDUSTRY_NAME,
       BEGIN_DATE,
       END_DATE,
       LEVEL_CODE,
       LEVEL_NAME
  FROM (SELECT COM_ID,
               INDUSTRY_D,
               INDUSTRY_NAME,
               BEGIN_DATE,
               END_DATE,
               LEVEL_CODE,
               LEVEL_NAME
          FROM (SELECT COM_ID,
                       INDUSTRY_D,
                       INDUSTRY_NAME,
                       BEGIN_DATE,