Teradata Write permission error

xinhuang66 · Post by **xinhuang66** » Tue Jun 12, 2007 7:27 pm

I try to load a seqential file to Teradata, creating a table as well.

The issue is if developerA first run the job and create the table, then developerB re-run the job again, developerB will encounter couldn't write tableName.dat file issue.

developerA and developerB are in the same Unix group.

Anyone can help ? Thanks.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 12, 2007 7:49 pm

It's not about UNIX permissions, it's about table privileges within Teradata. The first developer, creating the table, becomes its owner and has all privileges. The second developer has none, because neither the first developer nor the DBA granted any. Usually, when you create a table via an ETL tool, you should GRANT appropriate table privileges in the "after" (or "Close") command.

xinhuang66 · Post by **xinhuang66** » Tue Jun 12, 2007 8:35 pm

Both two datastage developers use the same standard Teradata login.

Actually, if I specify a detailed location and data file for teradata, and change the file permission, it works. But I think assign a detailed data file is not a good option.

nishadkapadia · Post by **nishadkapadia** » Tue Jun 12, 2007 9:21 pm

I believe you are not using named pipes as a option on the utilities.
it is preferable that you also check 'Delete data file after load' option
on the utilities.

That way both the developers would be able to run their jobs one after another.

xinhuang66 · Post by **xinhuang66** » Tue Jun 12, 2007 10:19 pm

Thanks for your input, I will test it and let you know the output.

What does "delete data file" option really do ? Assume it was set up as YES.

It will delete the source input file or whatever files regarding the job ?

Thanks