[fpc-pascal] Re: Connecting to Firebird using FPC/Lazarus over a LAN with user creation privilege

Reinier Olislagers reinierolislagers at gmail.com
Sun Mar 10 11:30:24 CET 2013


On 10-3-2013 11:21, Mark Morgan Lloyd wrote:
> reinierolislagers-Re5JQEeQqe8AvxtiuMwx3w at public.gmane.org wrote:
>> On 9-3-2013 14:08, Mark Morgan Lloyd wrote:
>>> I don't know whether anybody can help me with this one, but I'm working
>>> on something where I need a program to be able to create login-capable
>>> database users on-the-fly. I was hoping to be able to use either
>>> PostgreSQL or Firebird as the backend, but while Postgres is working
>>> fine Firebird is proving to be sufficiently difficult that I might just
>>> drop it.
<snip>
>> Have you tried the Firebird admin module that Ludo Brands wrote? It
>> connects using the FB service interface and allows user creation.
>>
>> Firebird also offers CREATE USER SQL AFAIR (since FB 2.5, perhaps
>> earlier)
> 
> I think gmail's delaying things :-) 
Very polite of you; actually I think it's PICNIC/PEBKAC at my end ;)

> I've not tried that yet, but it's on
> the list. I've just spent a while checking that some related SQL works
> with PostgreSQL (i.e. getting quoting correct etc.) since it's easier to
> debug.

As mentioned in other posts: you should be able to create users and
assign database permissions using SQL only (have confirmed the CREATE
USER/GRANT ROLE commands execute correctly with a third party tool,
FlameRobin (highly recommended for FB work) against a Firebird 2.5 db).

As you're using SQL for PostgreSQL as well, I'd suggest
not using the fbadmin module but doing everything in SQL.

If you hit problems, please feel free to contact me off list.

Thanks,
Reinier



More information about the fpc-pascal mailing list