Can I use a TIB_Script to modify the database ?

If so, I guess I can use something like:

GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON GROUPS TO USER NEWUSER;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON IPLOOKUP TO USER
NEWUSER;
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON SPRITEDETAIL TO USER
NEWUSER;

along with some kind of prefix to indicate the database is to be updated.
I'm looking for some SQL references on this but if anyone can answer this in
the meantime I'd appreciate it.

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



""Malcolm Smith"" <m.smith@...> wrote in message
news:b3biha$goi$1@......

> 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
>
>
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>