>A sproc has rights to access tables only in the database (DB) it resides in. If it access tables from another DB, you'll have to grant user the rights to those tables.

Sergey,

I think I found out the problem. Since the stored proc is executing a dynamic SQL statement with the EXEC() function, permissions are being checked on the statement inside the EXEC for the user executing the procedure.

Laterness,
Jon