Re: [Firebird-devel] User semantics vs authentication

[Jim S. <ja...@ne...>]

Vlad Horsun wrote:

>    One addition :
>
>    if we plans to implement cross database joins (inside 
>one server), we must have ability to identify users in different
>databases by its server logins.
>
>    I.e. when user with server login X logged in database D1
>perform statement like 
>    
>    select ... from D1.table1 join D2.table2
>
>where D1 and D2 are databases within the same server, we 
>must be able to autorize this user against database D2.
>
>
>  
>
This question has been around longer than Interbase.  The great 
unwritten component is traditionally called the mega-database manager.  
The MDM is a provider (using Vulcan terminology) in which virtual 
databases are defined from a number of physical databases.  The MDM 
manages virtual metadata, decomposes queries to underlaying databases, 
optimizes semi-joins, and generally acts as traffic cop.  In the grand 
scheme of things, handling target database account information is a 
necessary but relative simple task of the MDM.

The only things that has held back development of the mega-database 
manager have been time and money.  If anyone out there has the money, 
I'll be happy the find the time...

-- 

Jim Starkey
Netfrastructure, Inc.
978 526-1376