Skip to main content
Solved

Apps10 : Add new file path for migration job


Malan Jayanka
Sidekick (Employee)
Forum|alt.badge.img+9

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

Best answer by durette

GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 529 replies
  • Answer
  • August 18, 2021
GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;

 


Malan Jayanka
Sidekick (Employee)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Employee)
  • 35 replies
  • August 18, 2021

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


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 529 replies
  • August 18, 2021
Malan Jayanka wrote:

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

 


durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 529 replies
  • August 18, 2021

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings