Apps10 : Add new file path for migration job | IFS Community
Solved

Apps10 : Add new file path for migration job

  • 18 August 2021
  • 4 replies
  • 134 views

Userlevel 3
Badge +7

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

icon

Best answer by durette 18 August 2021, 17:18

View original

This topic has been closed for comments

4 replies

Userlevel 7
Badge +16
GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;

 

Userlevel 3
Badge +7

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

Userlevel 7
Badge +16

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

 

Userlevel 7
Badge +16

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.