I have tried to create a GLOBAL TEMPORARY table, but unfortunately with no success. The error message i get is ;
3524: The user does not have CREATE TABLE access to database DATABASENAME.
But I have Create Table access right on the particular database (, cross verifed also from DBC.AllRoleRights and DBC.RoleMembersV views). Still I am getting the error.
Can anyone help?
Jhansi Y B
Is your role active?
SELECT * FROM dbc.UserRoleRightsV;
Enable for the current session:
SET ROLE myRole;
MODIFY USER myUser AS DEFAULT ROLE = myRole;
Instead of myRole you might simply use ALL to enable all your roles