GRANT EXECUTE Question

From: <kachkar_at_my-deja.com>
Date: Mon, 20 Nov 2000 23:25:20 GMT
Message-ID: <8vcbsp$7qb$1@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 Mon Nov 20 2000 - 17:25:20 CST