At 05:00 PM 24/02/2003 +1100, you wrote:

>Helen,
>
>Based on your information I worked out how to use TIB_ConnectionSource to
>add the user - thanks.
>
>I have modified my CREATE DATABASE script so the owner is SYSDBA and GRANT's
>have been given for the user MATRIX. Once the database is created I can use
>TIB_Connection to add the user MATRIX and then login as MATRIX instead of
>SYSDBA.
>
>What I would like to be able to do (if possible) is:
>
>1. Add the User MATRIX before creating the database.
>
>2. Create the database with MATRIX as the owner.
>
>Is it possible to configure this component so you don't need to be connected
>to a database before you can add a user ?

The IBO components are database components, not service components. A
"connection" is a connection to one or more specified databases on a
running server, not an administrative interface to the server.

However, because the security database (ISC4.gdb) is a database, SYSDBA
(alone) can connect to it and update the USERS table.

You can use the IBX Service components in an IBO application. The big
problem with IBX is getting hold of bug-fixed sources, as Borland has
chosen to keep them hidden away. If you have D6 enterprise or higher, you
might like to give those versions a try.

Two IBO people have done service components that work with IBO. Try Dmitry
Belohistov's BDSLib components (link on our Contributed Code page) and/or
Lorenzo Mengoni's IBOAdmin package (www.mengoni.it)

Helen