Getting permission denied while trying to drop a table
Posted: Tue Mar 25, 2014 4:56 am
I am using NETEZZA as the database and using DATASTAGE VERSION8.5.
While using the DRS_CONNECTOR stage in the BEFORE SQL we are writing a drop table command on a particular table.But when we are running the job we are getting error as "DROP TABLE PERMISSION DENIED".
Although,we have permission for drop table in the NETEZZA database that we are using for this job.
This error we are getting for a specific job.When we are using drop command with same CONNECTOR stage in which is accessing the same database it is working fine.
Also we have not changed any parameter,for the job which is giving us this error.
Please provide us an urgent assistance as for this our work is on hold.
While using the DRS_CONNECTOR stage in the BEFORE SQL we are writing a drop table command on a particular table.But when we are running the job we are getting error as "DROP TABLE PERMISSION DENIED".
Although,we have permission for drop table in the NETEZZA database that we are using for this job.
This error we are getting for a specific job.When we are using drop command with same CONNECTOR stage in which is accessing the same database it is working fine.
Also we have not changed any parameter,for the job which is giving us this error.
Please provide us an urgent assistance as for this our work is on hold.