> 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.

You have to specify the role when connecting to the
database.


HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com