把多个用户的权限赋给一个用户脚本

 

SQL> spool  grantall.sql
SELECT   'GRANT ALL ON ' || owner || '.' || object_name || ' TO  testadm;'
 FROM   dba_objects
WHERE       owner like 'ADM%'
                     AND object_type != 'INDEX'
                     AND object_type != 'DATABASE LINK';
SQL> spool off
SQL> @grantall.sql