Privileges for Creating User-Defined Temp Tables
To create or modify temporary tables in the User-Defined Temp Table module, the logon user needs the following privileges:
-
Connection to DB2 LUW 7 or above
-
USE privilege on the USER TEMPORARY table space or SYSADM or DBADM authority.