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
View original
Apps10 : Add new file path for migration job
Userlevel 3
+9
This topic has been closed for comments
Userlevel 7
+18
GRANT ALL PRIVILEGES ON DIRECTORY ifsd_dm TO ifsapp;
Userlevel 3
+9
Hi
Do I have to run this as SYS user?
/Malan Jayanka
Userlevel 7
+18
Hi
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
+18
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.