grante execute on package to remote user oracle
Posted on 2012-03-20
I am trying to grant execute to packages in the WMIS database for users executing the package from the FMDR database.
They connect to the WMIS database via a link.
I have tried to grant execute to public from WMIS , but this does not solve my underlying problem, which is that oracle cant see my packages from teh package boday when they are being called from a remote user via a database link.
IN WMIS Database
EXECUTE ON TEG.PACKAGE_A TO PUBLIC
EXECUTE ON TEG.PACKAGE_B TO PUBLIC
Package A calls procdures from PAckage B. Code works fine from the WMIS database,
IN FMDR database we connect to wmis via DB_WMIS_LINK, but when we execute package_A from FMDR oracle gives the following error
ORA-06508: PL/SQL: could not find program unit being called
So to resolve this I am trying to grant any user that connects to teh WMIS database via the
database link execute privildges....
any help please ....