|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.You may well know all I'm writing here, just thought I should point it out if it happened to be a simple misunderstanding.
>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.
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.