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:
- The CREATETAB privilege to define a declared temporary table in the database that is defined AS WORKFILE, which is the database for declared temporary tables.
- The USE privilege to use the table spaces in the database that is defined as WORKFILE.
- All table privileges on the table and authority to drop the table. (Table privileges for a declared temporary table cannot be granted or revoked.)
These implicit privileges are not recorded in the DB2® catalog and cannot be revoked