Re: GRANT EXECUTE Question

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Fri, 24 Nov 2000 19:05:14 GMT
Message-ID: <KZyT5.53$Ty.3034@nreader1.kpnqwest.net>

Hi !

Your PL/SQL may be locker or used be another user .

See le v$lock table for locks.

If problem, drop the fucntion, create it again and then grant it.

<kachkar_at_my-deja.com> a écrit dans le message : 8vcbsp$7qb$1_at_nnrp1.deja.com...
> Hi all,
>
> When I run this command GRANT EXECUTE ON BIT TO PASD_USER; I get the
> following error message
> ORA-04021: timeout occurred while waiting to lock object PASD.BIT.
>
> Bit is a function and PASD_USER is a role identified by a password
> The weird thing is that when I run the same command against different
> function I have no problem with it . I do not understand why this is
> happening , and to make sure that nobody is locking the object I asked
> all users to logout then when I ran it again I got the same error
> message .
>
> Please can anybody explain to me what is happening .
>
> Thanks in advance
>
> Regards,
>
> Khaled
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 24 2000 - 13:05:14 CST