> 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.
