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.
Teradata Write permission error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am