I have two servers running SQL Server 2000
They each have 5 user databases (separated out by subject area)
They are configured exactly the same (one is production the other is training)

I have a situation where stored procedures in one database that select data from another database work correctly on the training servers but fail on the production server. They complain about lack of SELECT permissions on the table in the other database. Example in OrderDB there is an sp that selects data from a table in the ProductsDB. There are no permissions on any tables, all access to tables is through sp's. Everthing works correctly in training, but not in production.
We rebuilt master, dropped the user account from all database, dropped the role, re-added the login, re-added the role, granted exec on proceudres to role, re-added the user to all databases and place it in the role... No luck.

Any ideas?