Create TEMP TABLE :permission denied

Hi,

I am new to Crystal reports and trying to access the stored procedure from Nettezza via ODBC connection.The stored procedure returns a dataset and contains a temp table in it.When I try to access stored procedure in Crystal I got the error saying :Failed to retrieve data from the database.CREATE TEMP TABLE:permission denied.

I clearly know that I have the access in Nettezza to create a TEMP TABLE and the credentials used are same.

Can someone let me know the work around for this?

Thanks,

Pujitha