Some people can't execute a procedure

From: Stephen Andert <andert_at_gmail.com>
Date: Thu, 21 Feb 2008 11:55:38 -0700
Message-ID: <6d45e210802211055y391a9a1amcd36099b0857119d@mail.gmail.com>


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?

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 21 2008 - 12:55:38 CST

Original text of this message