Is the user heri1 a member of the role Administrator?

I don't think so. Execute:

GRANT Administrator TO heri1;

and try if the problem still exists, when you are trying to insert
records with heri1


HTH,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: Heri [mailto:heribender@...]
> Sent: Tuesday, August 27, 2002 9:09 PM
> To: IB_Support
> Subject: [ib-support] Roles and Permissions in FB 1
>
>
> 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
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>