We are setting up Talend tool recently and I am new to Talend.
We wrote a logic in Oracle stored procedures(Sp') to generate the files in Linux server .
We execute the Talend jobs from Tac, the files are generated by 'oracle' user but expectation is file should generate by Talend user/specific with full permissions .
How to configure to achieve this in Talend 7.3 . Appreciate your help.
If you are using an SP to generate the files, that is taking place inside Oracle. As such, they are being created by the user used to run the Oracle service (I assume that is your "oracle" user) or potentially the user you are logging in to Oracle with (I'm not 100% sure of that). Talend may be calling the SP, but you will be calling it via an Oracle user.
You *may* be able to engineer who owns the files with a change to the SP, but I don't believe you can make a change to the job to build the files with a different user.....unless you write the files using Talend.
However (I've just thought about this), you could use a tSystem component to call the chown command to change the owner of the files. The more I think about this, the more I am inclined to suggest you attempt that. The info I added at the beginning is still relevant, but on further thinking I suggest you try to change the owner of the files at the end of the job using a tSystem component.
What error are you getting when you try this? It is likely caused by the fact your user running the Talend job is not permitted to do this. Can you use sudo or use a user with the right permissions to run the job?
