EDQ Exported CSV Files Are Not Readable By All Users Due To File Permissions

(Doc ID 2371021.1)

Last updated on MARCH 14, 2018

Applies to:

Oracle Enterprise Data Quality - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

EDQ 12.2.1.2

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.

For example:

-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?

Changes

 

Cause

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