Is there a specific type that can be used in ACF2 for DB2 to control Global Temporary Table creation?
ACF2/DB2 does the same checking that IBM documents on Global Temporary Tables. In native DB2 you can grant ‘all’ to a user against a global temporary table. When a user does ‘alter, delete, insert, select’ on that table, it comes in under type TBL.
CREATE GLOBAL TEMPORARY TABLE
The CREATE GLOBAL TEMPORARY TABLE statement creates a description of a temporary table at the current server. Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
The privilege set that is defined below must include at least one of the following:
The CREATETMTAB system privilege
The CREATETAB database privilege for any database
DBADM, DBCTRL, or DBMAINT authority for any database
SYSADM or SYSCTRL authority
However, DBADM, DBCTRL, or DBMAINT authority is not sufficient authority if you are creating a temporary table for someone else and the table qualifier is not your authorization ID.
Additional privileges might be required when the data type of a column is a distinct type or the LIKE clause is specified. See the description of distinct-type and LIKE for the details.
Privilege set: The privilege set is the same as the privilege set for the CREATE TABLE statement. See information about CREATE TABLE Authorization for details.