| Package body Not visible [message #173931] |
Thu, 25 May 2006 05:05  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi,
Oracle version 9.2.0.6.0
i have created some packages and granted privileges on those packages to others users.
However, those users can only see the specification and no body at all for all those packages (they are using TOAD and SQL Developer, both)
i have also assigned them with 'grant select on dba_source'
Please suggest.
Thanks in Advance,
Pratap
|
|
|
|
|
|
|
|
| Re: Package body Not visible [message #173958 is a reply to message #173931] |
Thu, 25 May 2006 06:51  |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi Ebrian,
Is there any other way to achieve this.
As granting 'create any procedure' is really scaring me although it worked in this case.
Also the grant select on dba_source or all_source did not worked.
Please suggest.
Thanks in Advance,
Pratap
|
|
|
|
| Re: Package body Not visible [message #173961 is a reply to message #173958] |
Thu, 25 May 2006 06:59 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
Granting an ANY privilege should always be done with precaution. I can't think of another "direct" way of accomplishing this.
Have you tried, granting the developers access to DBA_SOURCE and creating a view of DBA_SOURCE, then grant the developers access to the view?
[Updated on: Thu, 25 May 2006 07:04] Report message to a moderator |
|
|
|
| Re: Package body Not visible [message #173977 is a reply to message #173961] |
Thu, 25 May 2006 07:46 |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
Try granting select_catalog_role and have them obtain the code by running a select statement like
select text from dba_source where name like '%PACK_NAME%';
-Sai Jeedigunta
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
