Granting file permissions

[Former Member]

Hi Experts!

BI is required to create a csv file when data is loaded, and place it in a directory in App server. Another system (XI) is going to read this file, and after reading , remove it to another folder in BI App Server for archival. Everything is happening in runtime... no manual intervention.

My requirement is to grant read & execute permission to the XI user so that it can read and then remove the file. How can I do so? It is a one time activity, so that permission can be given for XI user for all files? Or do I have to give permissions for each file when it is created?

If so, then how can i give the permission while creating the file?

This is a very urgent requirement, so please help me with this.

Thanks

Sushmita

[Former Member]

We used a shell script created in sm49, to run a chmod on the file...

Thanks to all helpful answers

[Former Member]

You'll need ot talk to your Basis / Server folks. Changing the permissions would normally be a server function, probably something a BW person would not have access to in most shops.

[Former Member]

Thanks Pizzaman ( do u actually deliver virtual pizzas??)

Its right that granting permission is a server issue. But for me, each file that is created has to be read and removed by another user... hence for every file created we have to change the permissions at the file level..

I have found some code to do that in sdn... but its not working..., not giving any error, but not working anyways... you can find the code in the following link if you want to refer..

Looking forward to your response.

Thanks

Sushmita

[Former Member]

Have you looked at using the OS Command Process in a Process chain. I haven't used it, so I don't know if you could issue a chmod command and appropriate parameters (file name, permissions, etc) but it should be easy enough to run a shell script that has a chmod in it.

Have you confirmed who the owner of the csv file is once it is created and what the chmod parameters need to be? I'd make sure that is all OK, then put it in a shell script and truy to run it from the process chain. Also - I think you want your XI user to have read / write permissions, not read / exe.