Grant permissions to all tables in schema
BEGIN
FOR TAB_NAME IN
(SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ‘
LOOP
EXECUTE IMMEDIATE ‘GRANT SELECT ON ‘ || TAB_NAME.TABLE_NAME || ‘ TO
END LOOP;
END;
BEGIN
FOR TAB_NAME IN
(SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = ‘
LOOP
EXECUTE IMMEDIATE ‘GRANT SELECT ON ‘ || TAB_NAME.TABLE_NAME || ‘ TO
END LOOP;
END;