PL/SQL (MOSC)

MOSC Banner

ORA-29280 with directory object granted read,write to a role

edited Sep 8, 2020 5:07AM in PL/SQL (MOSC) 2 commentsAnswered

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. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center