Dear Friends ,
we are using oracle 11g on Linux platform . My core application user is lets 'A' . All the tables , function, package , procedure are created by this core user 'A' .
I have another user 'B' . I give the select,insert,update,delete,execute all permission of all objects under 'A' to user 'B' .
Now , the problem is when user 'B' want to execute a function (function under a package) of user 'A' then it shows the below error :
"ORA-00904: "MIS_CB"."FXN_COR_LON_ELIGIBLE_SEC_AC": invalid identifier" .
Here ,
- MIS_CB is the package
- FXN_COR_LON_ELIGIBLE_SEC_AC is the function under the package 'MIS_CB'
Is there any solution to resolve this problem !!!