Skip to Content
avatar image
Former Member

Create TEMP TABLE :permission denied

Jan 15 at 05:37 PM | 49 Views

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

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Brian Dong
    Jan 15 at 05:44 PM

    Hi Pujitha,

    This usually means the account Crystal Reports is using to run the Stored Procedure does not have permissions to create the temp table in the procedure.

    Make sure you have the proper permissions. Try running the Stored Procedure in the database with the same Crystal Reports account and see if you get the same message.

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Brian Dong
      Jan 16 at 05:23 PM

      Hi Pujitha,

      So it's not a Stored Procedure you're calling, its a procedure in a Command Object. Crystal is designed to be read-only. It can't write back to the database, including temp tables.

      The temp table should be called inside the Stored Procedure and have the report attach the stores procedure same as you would a table. This way it's all handled on the database side and not on the client.

      I haven't worked with Netezza so I'm not sure how the stored procedure would be handled by Crystal. I'm assuming they have their own ODBC driver. I would have you test the ODBC driver in another program like MS Access to make sure the driver is calling the stored procedure properly as well.

      Good luck,

      Brian