?
Solved

grante execute on package  to remote user oracle

Posted on 2012-03-20
2
Medium Priority
?
1,603 Views
Last Modified: 2012-04-10
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
Comment
Question by:jhacharya
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 1500 total points
ID: 37745671
"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
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 37829481
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

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question