复制SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL s.sql SELECT GRANT SELECT ON " || u.object_name || " TO &1; FROM user_objects u WHERE u.object_type IN (TABLE,只读
VIEW,SEQUENCE) AND NOT EXISTS (SELECT 1 FROM all_tab_privs a WHERE a.grantee = UPPER(&1) AND a.privilege = SELECT AND a.table_name = u.object_name); SPOOL OFF -- Comment out following line to prevent immediate run @s.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.
