Subject RE: [firebird-support] firebird security.fdb
Author Alan McDonald
> Couple of questions.
> 1. I notice that the new security.fdb file is now dialect 3.
> Is this the reason it is now a minimum of about 3 times the size
> of the old
> dialect 1 database (at least as a starter size)? I have minimal users in
> mine and the D1 version is 260K and the D3 version is 640K.

OK - got me - it's page size which changes the file size - so pagesize of
1024 keeps it small but is this optimal?

> 3. I notice the Mr ODONOHUE is listed in system tables
> user_privleges of my
> security database as a user and grantor! Is this by design or error? OR
> could this be a left over from previous RC's? Hopefully this does not
> introduce a backdoor?
> Alan

the fbk file in the distribution does not have ODONOHUE listed - not sure
where my copy is derived from but it definitely has ODONOHUE replacing
SYSDBA in the HOST_INFO and ROLES records of the privileges system table.
I'm building a new security db from scratch.