Dear all,

I have a table MYTABLE and a user USER1 in the FB 1.5 database, what
I do is:

CREATE ROLE REF_READONLY
GRANT SELECT ON MYTABLE TO REF_READONLY
GRANT REF_READONLY TO USER1

However, when I login as USER1 and do a SELECT * FROM MYTABLE, I am
unable to select that table with an error saying: No permission for
read/select access to COLUMN MYTABLECOL1. I do not understand why
can't I select the table with USER1.

I check the RDB$USER_PRIVILEGES, I can see the following:

REF_READONLY SYSDBA S 0 MYTABLE
USER1 SYSDBA M 0 REF_READONLY

It seems that USER1 is the member of REF_READONLY.

Is there something I am missing here?

Regards,
Zion