permission for user

Posted by Roshan on Jan 24, 2023; 4:23pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/permission-for-user-tp11496.html

Hello Erman,

my environment has the following details:

Exadata Linux 8
Oracle DB 19c

we have 1 user gxuser which has primary group gftmove. Oracle has primary group oinstall.

Whenever we transfer files to a directory using gxuser, the files have primary group gftmove. When procedure runs, it is unable to delete the files unless we set the file group to oinstall or give them full permission 777.

 gxuser gftmove    12878 Jan 24 17:06 test.csv

chown gxuser:oinstall test.csv

Is there a way we can automatically change the file permissions to group oinstall for new files which enter the directory? or how can we set the files to 777?

Thanks,

Roshan