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
_______________________________________________________