Dynamic script for grants on a table

--  grants scripts

SELECT 'GRANT '
        ||PRIVILEGE||
      ' ON '||
        TABLE_NAME||
      ' TO '||
        GRANTEE||
       ';'
FROM DBA_TAB_PRIVS
WHERE(TABLE_NAME='&&TBL' OR GRANTEE='&&TBL')
ORDER BY TABLE_NAME,GRANTEE
/




-- Revoke script



SELECT 'REVOKE '
        ||PRIVILEGE||
      ' ON '||
    OWNER||'.'||
        TABLE_NAME||
      ' FROM '||
        GRANTEE||
       ';'
FROM DBA_TAB_PRIVS
WHERE(TABLE_NAME='&&TBL' OR GRANTEE='&&TBL')
ORDER BY TABLE_NAME,GRANTEE
/