Check if the user in Chicago has a sqlnet.ora file. This should show up if he/she does a tnsping. If there is, inspect the content. Compare it to your own sqlnet.ora. If there are differences, either replace the Chicago sqlnet.ora file with your own or remove it altogether. I don't know of a sqlnet.ora parameter that would cause this, but it's all I can think of. Finn On Thu, Feb 21, 2008 at 5:04 PM, Stephen Andert <andert@xxxxxxxxx> wrote: > I read the list a lot, but I guess I don't participate enough since I'm > not used to the automatic "reply to sender" instead of "reply to list". LOL > > On Thu, Feb 21, 2008 at 12:20 PM, Stephen Andert <andert@xxxxxxxxx> wrote: > > > Andrew, > > > > Sorry, I forgot to mention: > > > > DEV is still 9.2.0.2 (not work for some users) > > QA and above is 9.2.0.4 (does work for all tested users) > > Both servers are Solaris 5.8 > > > > Error: > > The user in Chicago gets this: > > > > ORA-06550: line 2, column 16: > > PLS-00904: insufficient privilege to access object USER_B.PROCEDURE_NAME > > ORA-06550: line 2, column 3: > > PL/SQL: Statement ignored > > I get: > > > > Procedure Completed > > > > Thanks > > > > > > On Thu, Feb 21, 2008 at 12:11 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> > > wrote: > > > > > oracle version, OS, and error message? > > > > > > > > > On Thu, Feb 21, 2008 at 12:55 PM, Stephen Andert <andert@xxxxxxxxx> > > > wrote: > > > > > > > > > > > USER_A cannot execute a procedure owned by USER_B when one person > > > > logs in. > > > > USER_A *can* execute a procedure owned by USER_B when a different > > > > person logs in. > > > > > > > > One person is in one city and the other is in a different city, but > > > > in TOAD, both users can "see" the procedure when browsing the > > > > procedures of > > > > USER_B. > > > > > > > > Furthermore, this is only the case in one environment (DEV) and > > > > works normally in other environments (i.e. QA) > > > > > > > > I have confirmed (in TOAD and SQL*Plus) that USER_A has EXECUTE > > > > privs on the procedure granted by USER_B. > > > > > > > > Help. What else can I try? > > > > > > > > > > > > >