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
Solved
Apps10 : Add new file path for migration job
+9Best answer by durette
GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;
This topic has been closed for replies.
+19GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;
If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
+9Hi
Do I have to run this as SYS user?
/Malan Jayanka
+19Hi
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
+19It’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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.