No data showing up in synonyms [message #414586] |
Wed, 22 July 2009 17:20 |
PLSQLPROB
Messages: 11 Registered: May 2003
|
Junior Member |
|
|
I need to view the code from packages information in Schema B from Schema A. I created a view for the packages in owner Schema A and granted select privileges to all the views in Schema A to Schema B. I created synonyms in Schema B and was able to see the code from user schema A as well as connecting as SYSTEM. I connected to Schema B and I am able to view the code from some of the synonyms that were created in Schema B, but I am unable to see the code in other synonyms in schema B as it returns with no rows selected even though I see there is code in the synonym when checked as SYSTEM user. What could be the reason? Are there any privileges that are missing. How can I view some packages and not the others? It is really confusing. Any help is appreciated.
[MERGED by LF; specified product and OS name]
[Updated on: Thu, 23 July 2009 00:40] by Moderator Report message to a moderator
|
|
|
|
Re: No data showing up in synonyms [message #414591 is a reply to message #414589] |
Wed, 22 July 2009 17:45 |
PLSQLPROB
Messages: 11 Registered: May 2003
|
Junior Member |
|
|
The reason why I am creating a synonyms is to have a read only code of these packages. I should not have the execute privilege on these packages. Since there are several packages, I wrote a script that generates the views for these packages and then the same is being created as synonyms in other schema. But in the other schema, I am able to view only a few synonyms and not all of them. Thanks for your quick response.
|
|
|
|
|
|
|
Re: No data visible in synonyms [message #414779 is a reply to message #414607] |
Thu, 23 July 2009 07:56 |
PLSQLPROB
Messages: 11 Registered: May 2003
|
Junior Member |
|
|
I would like to see all packages, package body and procedures from one of my schema into another schema. Is it possible to have all the source from one schema into another as read only? If it is possible, then how can we achieve this task. If not, is there any other way to get the above in some other way?
[Updated on: Thu, 23 July 2009 08:01] Report message to a moderator
|
|
|
|
Re: No data showing up in synonyms [message #415483 is a reply to message #414586] |
Tue, 28 July 2009 01:30 |
himang
Messages: 282 Registered: March 2005 Location: Bangalore
|
Senior Member |
|
|
Hi,
I guess "SELECT ANY DICTIONARY" privilege might help you but it would mean the schema having this privilege would be able to see package/function/procedure definitions for all the schemas.
|
|
|