Subject Roles and Permissions in FB 1
Author Heri
Hi all

I am very new to Firebird. Yesterday I installed FB 1.0 WI-V6.2.794 after I
haved worked with IB 5.5 on NT 4.0 and, currently, on a Win98SE machine.

My script to create a DB worked after some minor changes concerning the
Data/Timestamp datatype. But something with granting rights to roles does
not work correctly:

Create script:
-------------
...
Create Role Administrator;
...
Grant ALL on Objekt to Administrator WITH GRANT OPTION;
...

second script to populate the DB with some test entries:
-------------------------------------------------------
connect "D:\blabla...\Kultinfo.gdb" user "heri1" password "heri1" role
"ADMINISTRATOR";

insert into Person
(id, Name, Vorname, Vorname2, DisplayName, Geburt,
Geschlecht, TitelID, AnredeID)
values (
<blabla>
);
...

A before insert triggers tries then to insert some values into table Objekt.
This fails with the message:

No permission for insert/write access to TABLE OBJEKT
Statement: insert into Person
(id, Name, Vorname, Vorname2, DisplayName, Geburt,
Geschlecht, TitelID, AnredeID)
values (
<blabla>
);

All was committed properly during the creation of the DB.
BTW: This script worked correctly with IB 5.5

IBConsole
---------
The property page of table Objekt shows the correct permissions (by
"Administrator"). The detail page of "Roles" shows all Roles, but the
property page of role "ADMINISTRATOR" is empty.


What could be the issue here?

TIA

Heri