Authorization to run a data transfer

[Triel_2006]

Hi -

I am a bit confused. I have a user that needs to run a data transfer. It takes a file from the AS400 and puts it out on the IFS. I have given them *all permission to the AS400 file and have given them all in the IFS for "qas400\payroll". But when they run the data transfer it says something about not being authorized to SQL. There are no SQL statements in the data transfer itself that I see. It just takes a file "HRCSTA/ARPPROD1" and transfers it to "\\QAS400\PAYROLL\check recon\ARPprod1.txt". There are no selects or anything in the transfer. What do I need to give this guy to allow him to run this transfer? I certainly do not want to give him all object authority because he does not know anything about the 400. He is an IT person but once he found out he had to learn a few things about the 400 he just started taking options and was trying to vary lines on etc. I do not trust him to keep his hands off of things he knows nothing about.

Any help would sure be appreciated.

[tomholden]

Re: Authorization to run a data transfer

the data transfer tool is basically ODBC so everything is using SQL under the covers.

[Triel_2006]

Re: Authorization to run a data transfer

the data transfer tool is basically ODBC so everything is using SQL under the covers.

So how do I authorize him to use SQL? As I said I do not want to give him ALLOBJ authority. I am not sure how to authorize this.

Thanks!

[john.sev99]

Re: Authorization to run a data transfer

If I understand your post, you're using the data transfer tool to copy a file from the library file system to the /root file system? On the same machine?
Can't comment on the reason but is it possible to automate this on the system (CPYTOSTMF or some such command) rather than using the data transfer tool?

[tomliotta]

Re: Authorization to run a data transfer

... it says something about not being authorized to SQL.

Without knowing a little more about the error, it's hard to be sure of anything. A message identifier would be most useful since we could look it up to see what it means.

I would first guess that the specific user hasn't been granted a license to use the data transfer component of System i Access.

[Triel_2006]

Re: Authorization to run a data transfer

Without knowing a little more about the error, it's hard to be sure of anything. A message identifier would be most useful since we could look it up to see what it means.

I would first guess that the specific user hasn't been granted a license to use the data transfer component of System i Access.

This is so true! Smack me now!

I made a profile like his so I could test it and figure out why it wasn't working. He does not cooperate very much because he believes he should have full access to the system. But I did figure it out. It was giving error: CWBDB0036 Server returned SQL error.

He wasn't authorized to the library. So, you first have to be authorized to the library even if you have authority to the file inside the library it is separate for the library itself.

Thanks for your help!