Global Tempoary Table Error

Database

Global Tempoary Table Error

Hello Everyone,

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 MYUSERID.

Can anyone help?

Many thanks
5 REPLIES
Teradata Employee

Re: Global Tempoary Table Error

If you don't specify the DATABASE in which you are creating the global temp, it will be created in your username space. Then you need to have the propper rights and the TEMPORARY space allocated to your username in order to be able to create a global temp.
Since the global temp will be present in the DBC dictionary, you have to take care about the right and space managment
Senior Apprentice

Re: Global Tempoary Table Error

Try to create that table in a database where you got the needed "create table" right.

Your user doesn't need temp space to create a GTT, but perm space.
If you try to create a GTT in your own user you'll probably fail anyway, because most users don't have perm space.

You just need temp space to materialize an instance of it.

Dieter
Enthusiast

Re: Global Tempoary Table Error

Hello Everyone,

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?

Thanks

Jhansi Y B 

Senior Apprentice

Re: Global Tempoary Table Error

Is your role active?

SELECT * FROM dbc.UserRoleRightsV;

Enable for the current session:

SET ROLE myRole;

or permanently:

MODIFY USER myUser AS DEFAULT ROLE = myRole;

Instead of myRole you might simply use ALL to enable all your roles

Enthusiast

Re: Global Tempoary Table Error

Thanks Dieter...

Its working...