External Table

Hi

I have an external table on my 12.2 database.

The table uses 2 directories - one for data files and 1 for log files.  The schema owner has read on the data files directory object and read, write on the log files directory object.

I have a user that needs to select from the table.  The user was granted read on the DATA files director object.

In the select, the user specified "EXTERNAL MODIFY ( ACCESS PARAMETERS (NOBADFILE NODISCARDFILE NOLOGFILE) )", but they got the object not found error on the log files directory object.

When the user was granted read, write on the log files directory object, the select worked.