I came across a few application issues which related to the use of the Oracle directory objects in a few business functions, mainly you could come across one when there is functional requirement to import or extract data from or into file. It is basically a pointer to enable the Oracle database DBMS to access to the folder on the server. I usually find that the majority number of issue is, the user may not have the correct permission granted to access the directory objects and that is the most easiest thing to rectify.
To check if what permission has been granted for a given directory objects, you can use the following query:
Reference
Stackoverflow - Check rights on directory in Oracle
Imported from my old blog On the quest of a DBA's adventure......
No comments:
Post a Comment