At 05:27 AM 24/10/2005 +0000, you wrote:

>Hi Helen,
>
>Is this what you mean on the IBO's "two-layer" login:
>
>1) the application connects to the database using SYSDBA
>2) afterconnect, set FRED1 to IB_Connection.LoginUserName, and so on
>for FRED2, FRED3, and create record for each user in a log table.
>
>Questions: Would I able to extract all this user names from the list
>of aDatabase.Users without using a database log table? Using a log
>table is not reliable to catch current login if the application was
>shut down unexpectly.

No. The database engine only knows about user names that are in the
security database. Sure, it knows about SYSDBA, but you said you wanted to
log in all of your users as SYSDBA.

So, unless I've missed something, you are asking for something that simply
doesn't exist.

Helen