I'm getting an exception when an entity bean accesses a table:

javax.ejb.FinderException: Find failed:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544352. no
permission for read/select access to TABLE PROF_USER

However, the user in question is part of the PRODUCTION role:

GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON PROF_USER TO ROLE
PRODUCTION;

So how can the select fail if the user has permission to SELECT from the
table?

BTW, what actions does REFERENCES refer to?

Rick DeBay
Senior Software Developer
RxStrategies.net
561-650-8195 x-215