GRANT SELECT on all
tables in a schema
Single statement to grant privileges
FOR x IN (SELECT * FROM user_tables)
LOOP
EXECUTE IMMEDIATE ‘GRANT SELECT ON ‘ || x.table_name || ‘ TO
<< someone >>’ ;
END LOOP;
OR
DECLARE
CURSOR cur1 IS SELECT
TABLE_NAME from user_tables;
cmd varchar2(200);
BEGIN
FOR c in c1 LOOP
cmd := ‘GRANT SELECT ON ‘||c.table_name||<< TO
YOURUSERNAME>>’;
execute immediate cmd;
END LOOP;
END;