Is there a specific type that can be used in ACF2 for DB2 to control Global Temporary Table creation?
Note: The above protection is for Create Global Temporary Table.
There is no protection for DECLARE Global Temporary Table within ACF2 for DB2.
Per IBM Documentation:
None are required, unless the LIKE clause or AS fullselect is specified. In those cases, additional privileges might be required.
PUBLIC implicitly has the following privileges without GRANT authority for declared temporary tables:
These implicit privileges are not recorded in the DB2® catalog and cannot be revoked