Did you specify the role when you connected to your database? With
Firebird, it is not sufficient for the user to be granted the role, if
he doesn't specify the role when connecting, the error you mention will
be given.

HTH,
Set

elwin_ho wrote:

> 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