Build table grants

From Oramosswiki

--
--  Change History
--
-- Date         Author             Description
-- ===========  =================  ================================================
-- 26-JAN-2010  Jeff Moss          Created
--
SELECT 'GRANT '||privilege||' ON '||table_name||' TO '||grantee||
       (case when grantable = 'YES' THEN ' WITH GRANT OPTION;' ELSE ';' END)
FROM   dba_tab_privs
ORDER BY grantee
,        privilege
/

Which gives results like:

GRANT SELECT ON my_table TO user1;
GRANT UPDATE ON my_table TO user2;