Subject RE: [firebird-support] Re: Inssuficient rights for operation....
Author Svein Erling Tysvær
>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.

You may well know all I'm writing here, just thought I should point it out if it happened to be a simple misunderstanding.

It does not matter from where you log in. What does matter, is username (obviously) and that you connect using the correct role. Let's say I'm a member of two separate roles: DB_READ and DB_WRITE which have the obvious rights to a table that I have no access to myself. If I connect to the database specifying DB_WRITE as the role, I can do whatever I want, if I use DB_READ when connecting, then I can read, but not write data and if I do not specify any role when connecting, then I cannot do anything (not even read) unless rights have been granted me as a user rather than any role I'm a member of.