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
+9This topic has been closed for replies.
+19GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;
+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.