• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1830
  • Last Modified:

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 ....
0
Jayesh Acharya
Asked:
Jayesh Acharya
  • 2
1 Solution
 
Wasim Akram ShaikCommented:
"ORA-06508: PL/SQL: could not find program unit being called"


EXECUTE  ON  TEG.PACKAGE_A TO PUBLIC
EXECUTE  ON  TEG.PACKAGE_B TO PUBLIC

instead of giving the access to public, you could have given to the user to who owns the db link.. anyways this should not be a problem..

i think the problem is something different inside these packages there may be some function/procedure/package calls on which the fmdr dblink user doesnot have privilege to execute which is causing the problem indeed..

but try giving like this

grant all on TEG.PACKAGE_A to <db_link_user>/public

grant all on TEG.PACKAGE_B to <db_link_user>/public



how are you executing the script, it will give you more generic message rather than what you have mentioned here.. it will give you something like this

at line 280:
ORA-06508: PL/SQL: could not find program unit being called
ORA-0

paste the total error message... if you get the line number then you can go that particular line number and see what object is there and grant execute on that particular object to the dblinkuser again and try once more..
0
 
Wasim Akram ShaikCommented:
jhacharya.. can i know the reason for the penalty grade..??

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..!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now