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 DECEMBER 12, 2019

Applies to:

Oracle Enterprise Data Quality - Version 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.

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: Permission denied

Why are the permissions different, and how can other users access this file?




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

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