Hi,

I'm using IBObjects to create my database using this script:

CREATE DATABASE
'IBData\Matrix.gdb'
USER 'SYSDBA'
PASSWORD 'masterkey'
PAGE_SIZE 4096;
commit;
// etc

The application is now finished but I want to be able to allow the user the
option of changing the login details to gain access to the database.

I thought I could just add a new user using IBConsole but then I realised
the above script was being used, hence no other user has access.

What do I have to do so a user of the application can enter a new user in
IBConsole and then configure our application to use this new user in place
of the default.

Each installation will require a unique username and password because of the
nature of the environment.

The application is installed as a 7 day trial and hence the default
installation creates the table as above. Would I have to create a new
database and transfer the information or is there another way ?

IBConsole allows me to to my database using 'Connect As...' - there must be
a way I can do this in code too, yes ?

TIA.

--
Malcolm Smith
MJ Freelancing
http://www.mjfreelancing.com