At 02:47 AM 26-09-02 +0000, you wrote:

>Hi Helen, thanks for your reply.
>
>No, it has no suspend statement.
>sp is below:
>
>CREATE PROCEDURE UPD_LAST_USE
>AS BEGIN
> UPDATE EXCH
> SET LASTUSE = 'NOW';
>END ^
>
>Could it be because the role has EXECUTE, not the actual user?
>(even though the user is a member of the role)

It shouldn't be. Provide the user has privileges to the role, it should
have the privileges granted to the role.

Do you know for sure that the procedure has sufficient privileges...I
noticed that your syntax looked incomplete:

GRANT ALL ON EXCH TO UPD_LAST_USE

should be

GRANT ALL ON EXCH TO PROCEDURE UPD_LAST_USE

Does EXCH have other dependent tables that the procedure doesn't have
privileges for?

Have you queried to see whether MICK actually is a member of STORE? (SHOW
ROLES in isql)

What does a query on RDB$USER_PRIVILEGES tell you?

heLen