Hi,

I don't succeed to grant privileges to a user with a ROLE. I did
the following : I've created a simple table to the test,
named 'ROLETEST'. NCW is my username.

1) CREATE ROLE NEW_ROLE
2) GRANT SELECT ON ROLETEST TO NEW_ROLE
3) GRANT NEW_ROLE TO NCW

When I log on with NCW and try to read from the table, I got the
error message : no permission for read/select access to TABLE ROLETEST

When I grant direct priviliges to NCW without a role, it's working.
I'm using Firebird 1.0

Thanks in advance for helping,

Nico Callewaert