Permission denied creating temp table in Netezza called python script

[Visalini323]

Getting the following error
1843, in execute
raise ProgrammingError(self.error)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
nzpy.core.ProgrammingError: ERROR: CREATE TEMP TABLE: permission denied.

while trying the below code
import nzpy
import pandas as pd

Database connection parameters

host = 'host'
port = 1234
user = 'user'
password = 'password'
database = 'DBBB'

SQL query

query1 = "DROP TABLE TEMPTABLE123 IF EXISTS;"
query2 = "CREATE TEMP TABLE TEMPTABLE123 AS SELECT s.div, s.div_name from DBBB..STORES s GROUP BY 1,2;"

Establish connection to Netezza database

with nzpy.connect(host=host, user=user, password=password, database=database, port=port, securityLevel=1,logLevel=0,) as conn:

Create a cursor object

cur = conn.cursor()

Execute the query

cur.execute(query1)
cur.execute(query2)

but with the same user , password able to create the temp table through DBeaver tool.
Able to run those 2 queies from the SQL editor of the DBeaver tool using same user name and credentials
Please suggest solution
thanks