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

[Mark Morgan Lloyd]

Reinier Olislagers wrote:

>> Subject to a maximum user name length of 31 characters on Firebird. The
>> manual suggests that PostgreSQL has a limit of 64.
>>
> 
> If you're going to list all differences between PG and FB as you hit
> them, you might put them on a wiki page for easy retrieval by others.
> The table/trigger/sp/view/general object name max length in FB is  about
> 32 bytes IIRC.

True, but I thought that a detail relating to something that people were 
likely to do comparatively infrequently (i.e. user management by a 
custom app rather than by something like Flamerobin) was worth getting 
into the record.

> I suppose you found out FB has an 8 char effective password? You can use
> more letters but MASTERKE is the same as MASTERKEY. Of course this goes
> away if you use trusted authentication/OS authentication.

I hadn't yet, but I was going to hash (etc.) the user's submission 
anyway so that it could be stored and moved around without grave risk. 
Which obviously introduces issues when communities with different salt 
are merged... and so on :-)

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

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