SQL> Set define off
SQL> CREATE OR REPLACE VIEW ANQINGDB.V_tablecolumnInfo
AS
select c1.table_name,c1.column_name,c1.data_type,c1.data_length,c1.nullable,c2. comments
from user_tab_columns c1,DBA_COL_COMMENTS c2,DBA_TAB_COMMENTS c3
where c1.table_name=c2.table_name and c1.table_name=c3.table_name and c1.column_name=c2.column_name and c2.owner='ANQINGDB' and c3.owner='ANQINGDB'
and c2. comments is not null
ORA-01031: 权限不足
SQL> CREATE OR REPLACE VIEW ANQINGDB.V_tablecolumnInfo
AS
select c1.table_name,c1.column_name,c1.data_type,c1.data_length,c1.nullable,c2. comments
from user_tab_columns c1,DBA_COL_COMMENTS c2,DBA_TAB_COMMENTS c3
where c1.table_name=c2.table_name and c1.table_name=c3.table_name and c1.column_name=c2.column_name and c2.owner='ANQINGDB' and c3.owner='ANQINGDB'
and c2. comments is not null
ORA-01031: 权限不足
grant select on DBA_TAB_COMMENTS to ANQINGDB
grant select on DBA_COL_COMMENTS to ANQINGDB但是推荐把语句改成
CREATE OR REPLACE VIEW ANQINGDB.V_tablecolumnInfo
AS
select c1.table_name,c1.column_name,c1.data_type,c1.data_length,c1.nullable,c2. comments
from user_tab_columns c1,USER_COL_COMMENTS c2,USER_TAB_COMMENTS c3
where c1.table_name=c2.table_name and c1.table_name=c3.table_name and c1.column_name=c2.column_name and c2. comments is not null