Subject Re: [firebird-support] Security.fdb improvements
Author Salvatore Besso
hello all,

maybe you remember this old thread where I asked if it was safe to add
fields to security.fdb to enhance it. Ann (Harrison) said "yes, but make a
copy first, just to be safe".

Ok, I have modified security.fdb adding some simple fields and it works
well. When I connect to a database, authentication is fine as usual. Then,
after the connection to the main db, I try to connect to security.fdb using
a separate connection and an alias defined in aliases.conf to retrieve the
extra data, but it seems not possible to connect to security.fdb at this
stage using the alias, because I get:

I/O error for file security.fdb
file not found

Instead, if I specify the exact local path

C:\Programmi\Firebird\Firebird_1_5\security.fdb

without using the alias, I can connect to security.fdb. The alias in
aliases.conf is correct as visible above (I have an Italian Windows). It
seems that Firebird doesn't like an alias to connect to the security
database itself.

If the connection with the alias is not possible it's a trouble since this
mechanism with the new fields cannot work.

To be as precise as possible, I'm using IB Objects 4.6A for the connections.

Any clue?

Regards
Salvatore