On 13-4-2011 12:34, Vlad Khorsun wrote: >> In this way, you lose dynamic registration, and have the administrator >> manage the list of databases shown in RDB$DATABASES. > > In what database ? > > Regards, > Vlad Hi Vlad,
You mean in what database does RDB$DATABASES reside? You got the weak point in my original argument, which I had overlooked. Yes, you would need to connect to the server with valid credentials, and retrieve this table. I had thought to supply RDB$DATABASES in all regular databases as it is generated by the database engine anyway. However, how do you know with what database to connect in the first place - Firebird won't allow you to connect without a database at the moment. Chicken & egg problem. Right now, I see 3 ways to solve this: 1. Just insist users connect to an existing database, same as now. A bit stupid; you might misuse employees.fdb for this but it would still be inelegant. 2. Allow connections for these serverwide maintenance/query tasks without a database specified. Needs code changes, obviously. 3. Use a default database, e.g. specified in aliases.conf, equivalent to SQL Server/Sybase master. Maybe even use a security database for this (note: I know nothing about security implications regarding this option)? Downside: any user with an existing database called this will have to change their db name. If you mean "where does the admin keep track of the list of databases that will be shown in RDB$DATABASES": this list will still be generated by Firebird by reading aliases.conf, so the admin will maintain aliases.conf just like he is doing now. -- Regards, jb ------------------------------------------------------------------------------ Forrester Wave Report - Recovery time is now measured in hours and minutes not days. Key insights are discussed in the 2010 Forrester Wave Report as part of an in-depth evaluation of disaster recovery service providers. Forrester found the best-in-class provider in terms of services and vision. Read this report now! http://p.sf.net/sfu/ibm-webcastpromo Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
