可以创建一个存储过程来进行调用，写上对应的模式，用户，操作类型即可。
CREATE PROCEDURE GRANT_ROLE_QUANXIAN(READ_SCHEMA VARCHAR(128), ROLE_NAME VARCHAR(128), TYPE_NAME VARCHAR(128)) AS
DECLARE
SQL_TEXT VARCHAR(30000);
TAB_NAME VARCHAR(128);
V_CUR CURSOR;
BEGIN
OPEN V_CUR FOR SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER= READ_SCHEMA;
LOOP
FETCH V_CUR INTO TAB_NAME;
EXIT WHEN V_CUR%NOTFOUND;
SQL_TEXT = 'GRANT ’ || TYPE_NAME || ’ ON '|| READ_SCHEMA || ‘."’ ||TAB_NAME|| '" TO ’ || ROLE_NAME;
EXECUTE IMMEDIATE SQL_TEXT;
END LOOP;
CLOSE V_CUR;
END;

SELECT ‘grant select on ‘||OWNER||’.’||TABLE_NAME||’ TO USER2’
FROM DBA_TABLES
WHERE OWNER=‘USER1’ AND TABLE_NAME LIKE ‘T%’;
先查询出授权语句，然后执行。