> 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
http://www.upscene.com

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