Subject Re: [firebird-support] How do I change the password for an Interbase GDB?
Author Artur Anjos
Hi Mike,

Others already answer your question, this is just to give you some advice.

This is just a reminder to other subject: keep in mind, in your application,
that the IBServer is not exclusive of your application. You should always
think that the Interbase/Firebird server is there to any aaplication that
wants to use it, not only yours.

The recommended way is to create a user, that owns the database. Your
application should check if there is already a Ib/Fb server running on the
machine, and if it is it should ask for the sysdba password, so you can
create your user with the password you define, and go on.

The sysdba password should be something that your client needs to know, not
you or your application. :-)

If you follow this procedure, you will have the warranty that your
application will never interfere with other applications that use the same
server.

I hope this helps,

Artur



----- Original Message -----
From: "M Tuttle" <miket@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, June 24, 2003 1:16 PM
Subject: Re: [firebird-support] How do I change the password for an
Interbase GDB?


> I'm using Database Workbench and want to release my first application on
> demo CD's. So I would like to make sure that the SYSDBA password is
> something other than the default. I would then like to change the SYSDBA
> password on the two databases I have out in the field. We do not use the
> ISC4.GDB database to add users. We basically log everyone into the
> production gdb with SYSDBA masterkey and then use an internal user table
for
> user codes, passwords, security rights, etc for the application. So do I
> simply send out a new ISC4.GDB database with a different password for the
> SYSDBA?
>
> Thanks
>
> Mike
>
> ----- Original Message -----
> From: "Nick Upson" <uebridger@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Tuesday, June 24, 2003 7:06 AM
> Subject: Re: [firebird-support] How do I change the password for an
> Interbase GDB?
>
>
> > >From: "M Tuttle" <miket@...>
> > >I would like to change the password for the SYSDBA masterkey user to
> > >something else.
> > >
> > >How do I do it on my copy of the database?
> >
> > you can't, the users relate to the installation not a specific database
> >
> > >Can I run an update script to change the password out in the field? If
> so,
> > >how? If not, what must I do?
> >
> > unless you want to directly update system fields you can't do it with a
> > script.
> >
> > Which tool(s) are you using? then we can talk you through it
> >
> > _________________________________________________________________
> > Find a cheaper internet access deal - choose one to suit you.
> > http://www.msn.co.uk/internetaccess
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>