Re: Some people can't execute a procedure
- From: "Don Seiler" <don@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Thu, 21 Feb 2008 13:18:38 -0600
Is it the USER that has the execute privs, or some role granted to the
user? If so, is the role a default role? If not default, is there a
logon trigger that conditionally sets the role upon user login?
Don.
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?
>
>
>
--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l
Other related posts:
