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)

-Ryan

> What kind of SP is it? If it contains a SUSPEND statement, I

think the

> engine considers it a selectable stored procedure - meaning

(possibly) the

> user needs SELECT rights on it as well.
>
> heLen