Hi,
I am using Firebird 1.5, and having problem to grant permission to
the existing user through role.

Steps:
0. Create a user "test"

>C:\Program Files \Firebird\bin>gsec.exe -user sysdba -password

masterkey -database 127. 0.0.1:"c:\Program
Files\\Firebird\security.fdb"
GSEC> ADD test -pw test -fname test -mname test -lname test

1. Create a role

>create role ROLE1;

2. Grant the ROLE1 to test

>grant ROLE1 to test

3. Create a table (by sysdba):

CREATE TABLE "EEE9"
(
"ID" varchar(10) NOT NULL,
PRIMARY KEY ("ID")
);
4. Grant the table to ROLE1

> grant all on EEE9 to ROLE1

5. Access the table with user "test".

> select * from EEE9

and I get:

>[Error] Script lines: 1-1 --------------------------

GDS Exception. 335544352. no permission for read/select
access to TABLE EEE9

It works if I grant the permission to user "test" or "public"
directly. But not through the role. Did I miss any?

Thanks in advance
Elwin