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 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:\Daten\Heri\Programmieren\Projekte\Kulti\Kultinfo\DB\Kultinfo.gdb"
user "heri1" password "heri1" role
"ADMINISTRATOR";
insert into Person
(id, Name, Vorname, Vorname2, DisplayName, Geburt,
Geschlecht, TitelID, AnredeID)
values
(0,'Bender','Heri','','Heri Bender','07.03.1957',
'm',
(Select ID
from Titel
where Bezeichnung = ''),
(Select ID
from Anrede
where Bezeichnung = '')
);
...

A before insert triggers tries 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
(0,'Bender','Heri','','Heri Bender','07.03.1957',
'm',
(Select ID
from Titel
where Bezeichnung = ''),
(Select ID
from Anrede
where Bezeichnung = '')
);

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


What I am doing wrong?

TIA

Heri