Try creating synonym for user.procedure as procedure_name

-----Original Message-----
From: EXT-Dunn Duane D
[mailto:oracledba-ezmlmshield-x76428997.[Email address protected]
Sent: Tuesday, April 03, 2007 2:13 PM
To: LazyDBA Discussion
Subject: Grant issue

I have a procedure in a package that access another package procedure in
a different schema. I do not want to have to put the schema name in
front of the
called package procedure to get it to compile. What grants will allow me
to do this...see below


Schema DDB
Code in package procedure DDbWebform.drawinlist that access
reportserver.pdf
htp.tabledata('<A
HREF="'||reportserver.pdf||'ddb_actdetail_rdf+P_DRAWING_NUMBER='||replac
e(c1.dwg_number, ' ', '+')||
'">'||c1.dwg_number||'</A>');


Reportserver.pdf resides in schema raicore

What grant will allow me not to have to specify the schema before the
procedure? I have tried to grant all on reportserver to ddb while in
raicore but I still need to put raicore in front of the procedure to get
it to compile.

Duane Dunn
206.655.5936 M/C 14-ME




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page