Skip to main content

Hi,

A directory is already defined in ALL_DIRECTORIS.
 


But this is not visible in migration job → file path field.


Does Any one have an idea about how to add that directory into File Path LOV.


/Malan Jayanka

GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;

 

Hi @durette 
Do I have to run this as SYS user?
/Malan Jayanka

Hi @durette 
Do I have to run this as SYS user?
/Malan Jayanka

Yes. Attempting to do this as the app owner will give you an error:

ORA-01749: you may not GRANT/REVOKE privileges to/from yourself

 

It’s also not enough to grant system privileges to the app owner to solve this because the IFS view ORACLE_DIRECTORIES does a WHERE EXISTS against DBA_TAB_PRIVS. It needs explicit grants.

Terms & ConditionsCookie settings