Hi,
How then should I deploy my database, with a changed password? Can I run
Gsec on the server from inside my Script, before I connect?
or modify isc4.gdb from inside my script?

Thanks
Daniel






At 11:59 AM 26/02/2002 +1100, you wrote:

>At 05:05 PM 25-02-02 -0800, Daniel Bertin wrote:
> >Hi all,
> >
> >On a new create database;
> >SET SQL DIALECT 3;
> >CREATE DATABASE 'C:\Test-Gdb\Test.gdb'
> > USER 'SYSDBA'
> > PASSWORD 'newgen'
> > page_size = 4096;
> >
> >what is the proper, and suggested way to change the user name and password
> >on the database, and still have the admin rights. when I change it in this
> >SQL, on creation of the database,
> >I get an error, Your user name and password are not defined when I try and
> >connect to the database.
>
>User names and passwords apply at server level, not for individual
>databases. The database you created is owned by a SYSDBA whose password is
>'newgen'. In order to access this database you will have to run it on a
>server whose isc4.gdb has this password for SYSDBA. If you are logged in
>as SYSDBA you can change the password using GSEC or the Users facility in
>IB_SQL.
>
>cheers,
>Helen
>
>All for Open and Open for All
>Firebird Open SQL Database · <http://firebirdsql.org>http://firebirdsql.org
>_______________________________________________________
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=219350.1849043.3355872.1269402/D=egroupweb/S=1705115386:HM/A=935585/R=0/*http://www.gotomypc.com/u/tr/yh/grp/300_1b/g22lp?Target=mm/g22lp.tmpl>271a33b.jpg
>271a3f9.jpg
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

[Non-text portions of this message have been removed]