Subject Re: [Firebird-Architect] Nice to have features for ISP's Hosting FB (imo)
Author Daniel Rail
Hello Simon,

Tuesday, September 28, 2004, 12:02:13 PM, you wrote:

> The following is a list of what I would consider nice to have features when
> hosting fb 1.5 in an isp environment. My apologies if some/all have been
> suggested before as I'm new to the list.

> 1. Alias Manager API - I have searched but have not found anything
> about this.

You are right. It doesn't exists in Firebird. But, I don't know
about Vulcan.

> 2. Ability to disable users.
> 3. Ability to assign users to databases, preferably using security.fdb.

Points 2 and 3 are on-topic with the user management/authentication
threads currently going on.

> 4. Improved logging, allow:
> - Log failed connections.
> - Log successful connections (user and database).
> - log ip address for all log items
> - change log file to delimited format for easy importing into other
> apps
> - Log bandwidth (in/out) by user - Maybe too much but worth asking
> :-)
> - Log code for easy searching of log's
> - Maybe using security.fdb for logs (this might not be too clever in
> long run)
> - Daily log files instead of 1 all encompassing log file.

> 5. Option to disable non sysdba use of server api functions.

This would actually be a nice feature and fits within the security

> 6. Ability to ban ip that has N failed connection attempts in specified
> time period.

Maybe add a feature to ban for a certain period of time. But, it is also
pointless if the user is on a dynamic IP that changes every hour, or a
dial-up user.

> 7. Global UDF's that do not have to be declared in each database.

This I would also go for.

And, there's also the possibility to have someone implement(for a fee)
the features that you are asking. You can go through the Firebird

Best regards,
Daniel Rail
Senior Software Developer
ACCRA Group Inc. (
ACCRA Med Software Inc. (