ORA-29280 with directory object granted read,write to a role
I'm switching from UTL_FILE_DIR to directory objects as required by 19c. I have created a set of directory objects. Then I granted READ and WRITE permissions on them to roles. However, when I run code that has been modified to use directory objects it returns ORA-29280. The specific function being used is UTL_FILE.FRENAME. If I grant READ,WRITE permissions on the directory objects directly to the application schemas then the code works.
I looked around and found that "Ask Tom" seems to indicate that I cannot grant permissions on directory objects to roles but must instead grant directly to users.