Subject Re: [firebird-support] Permission denied with qli and isql
Author Ted Miglautsch
>
> 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.