My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.