Hi,

I encountered some problems regarding grant and roles in the latest
Firebird build. I couldn't test other versions so far.
Here's a basic test-case that reproduces the problem:

~/>>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '~/Data/User/Test.fdb';
SQL> create table test( Field1 Integer, Field2 VarChar(30) );
SQL> create role test_role;
SQL> grant select on test to role test_role;
SQL> grant test_role to dalbu;
SQL> exit;
~/>>isql -u dalbu -p password
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect ~/Data/User/test.fdb;
Database: ~/Data/User/test.fdb, User: dalbu
SQL> select * from test;
Statement failed, SQLCODE = -551

no permission for read/select access to TABLE TEST
SQL>

Is my understanding of roles wrong?
That's how it's described in the data definition guide,
at least that's how I understand it.

thanks for any help,
Daniel Albuschat

--
eat(this); // delicious suicide