• You can programatically do it with dynamic SQL or you can copy paste a bunch of lines only changing the table name (Object name)..

    Simplified syntax for GRANT

    GRANT { ALL [ PRIVILEGES ] }

    | permission [ (column [ ,...n ] ) ] [ ,...n ]

    [ ON [ class:: ] securable ] TO principal [ ,...n ]

    [ WITH GRANT OPTION ] [ AS principal ]

    Simplified syntax for DENY

    DENY { ALL [ PRIVILEGES ] }

    | permission [ (column [ ,...n ] ) ] [ ,...n ]

    [ ON [ class:: ] securable ] TO principal [ ,...n ]

    [ CASCADE] [ AS principal ]

    Just change the object name and repeat the code

    --Pra:-):-)--------------------------------------------------------------------------------