> > 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. >
Not having access to the lockfiles might be a major part of the problem. I have played with the RDB$OWNER_NAME field on the RDB$RELATIONS table. By changing that to the user created in the gsec program I was able to get access to one of the databases from flamerobin. But I suspect flamerobin is forcing the connection through tcp/ip.
