Subject RE: [firebird-support] Permission denied with qli and isql - Email found in subject
Author Leyne, Sean
> > Add those users to the firebird group, or make sure all those programs
> > use the service manager or tcp/ip connection to attach to the
> > database. The problem is now that they try to access the database as a
> > local database (which AFAIK means it behaves as a privately owned
> > classic server process), but can't get it to work as they don't have
> > access to shared resources like the lockfiles.
> >
> Accessing the databases through the tcp/ip connection is way too slow.
> Their programs read and write billions of records as quickly as possible. I was
> disappointed when IB eliminated the shared memory connection to the
> database engine. It was faster than the pipe connection. The tcp/ip
> connection is even slower.

> I tried adding the users to the firebird group but still the same "Permission
> denied" error. I tried having the database owned by either the user and
> firebird. It did not matter. I remember that with IB 2007 the user no longer
> owned the database. It was root.

Firebird is based on the IB v6.0 code base released by Borland/Inprise... IB 2007 is a later closed source release.

What Firebird release/version # and version of the engine (Classic, SuperServer, SuperClassic or Embedded) are you trying to access?