declare
cursor c1 is select table_name from user_tables;
cmd varchar2(200);
begin
for c in c1 loop
cmd := 'GRANT SELECT ON '||c.table_name||' TO "userid"';
execute immediate cmd;
end loop;
end;
Thanks to :
https://forums.oracle.com/forums/thread.jspa?threadID=616903