view往往关联很多基表，使用如下命令可以找到需要授权的基表，然后进行相应的授权http://www.cndba.cn/hbhe0316/article/108522http://www.cndba.cn/hbhe0316/article/108522

select (case
           when t.type = 'VIEW' then
            'GRANT SELECT ON ' || t.referenced_owner || '.' ||
            t.referenced_name || ' WITH GRANT OPTION;'
           else
            'GRANT EXECUTE ON ' || t.referenced_owner || '.' ||
            t.referenced_name || ' WITH GRANT OPTION;'
         end) shouquanyuju
    from all_dependencies t
   where t.owner = '<SCHEMA_NAME>'
     and t.name = '<TABLE_NAME>'
     and t.type in ('VIEW', 'PROCEDURE', 'FUNCTION', 'PACKAGE BODY');

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle