Execute the anonymous block below:
DECLARE
STMT VARCHAR2(100);
BEGIN
FOR x IN (SELECT TABLE_NAME FROM user_tables)
LOOP
STMT := 'GRANT SELECT ON ' || x.TABLE_NAME || ' TO <user>';
EXECUTE IMMEDIATE STMT;
END LOOP;
END;
No comments:
Post a Comment