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

[Mark Morgan Lloyd]

Reinier Olislagers wrote:

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

Thanks, noted.

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

I'm trying to :-) But I was hoping that Firebird would be easy after the 
number of people who compliment it, and that it would be a good fit for 
"leaf" servers since- like Postgres- it has a notification mechanism.

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

Thanks very much, noted.

-- 
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]