Subject Re: [firebird-support] Re: Inssuficient rights for operation....
Author Thomas Steinmaurer
> Hello. I used Firebird 1.5.6 on server on WIN7, a database with a role with
> full rights, and a user defined in ROLE, USER.
> I have a problem. In the network with a application, on different client
> station, login with the USER, all functions work OK.
> From server or another WIN7 station, with USER login, a have one error, with
> insufficient sql rights for operation, no permission to read/select acces to
> TABLE. All different functions work OK. ROLE with GRANTS in all tables.
> The solution from win7 is to give rights on USER for table CONFIG_BALANTA, the
> rights from the ROLE give this error
> WHY THE DIFFERENT functionality? Same user, same rights on database.

Is the user is providing the role name at connect time?

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.