EDQ Exported CSV Files Are Not Readable By All Users Due To File Permissions
Last updated on MARCH 14, 2018
Applies to:Oracle Enterprise Data Quality - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
When exporting a newly created Data Store to a csv file, it is being created with permissions of 640 (-rw-r-----). with ‘oracle’ user to the "../products/app/data/edq" directory. The group is assigned as oinstall. Because of this, users that are not in the oinstall group are unable to access this file. As the "oracle" user, creating a file in the same directory results in the creation of a file with permissions of 644 (-rw-r--r--). These files can be read by "other" users.
-rw-r--r-- 1 oracle oinstall 0 Feb 21 07:00 test (file created by oracle user directly in this directory)
-rw-r----- 1 oracle oinstall 6437852 Feb 21 08:38 PRODUCT_BATCH_DQ_REPORT.csv (export file created by the EDQ export)
As a user that is not in the install group (and not user oracle):
$ cat PRODUCT_BATCH_DQ_REPORT.csv
cat: PRODUCT_BATCH_DQ_REPORT.csv: Permission denied
Why are the permissions different, and how can other users access this file?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms