Jayesh Acharya
asked on
grante execute on package to remote user oracle
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 ....
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 ....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
the question has been well answered.. if you had needed further clarifications, you could have asked more.. can you let me know what has been missed out here..
if you think nothing has been missed out.. then you should have closed this question with proper grading..!!