At 02:12 AM 18/12/2003 +0000, you wrote:

>I have tried to create a database with different username and
>password other than sysdba/masterkey.

The masterkey password can (and should) be changed to something else.

Any user can own a database. You can either log in to isql or your
favourite admin tool as that user, and create the database; or you can log
in as sysdba and specify the owner in the CREATE DATABASE statement in your
script.

>But it is not successful.
>
>How can create a database with a different username and password?

CREATE DATABASE 'D:\DATA\SOMETHING.FDB'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1
USER 'FRED'
PASSWORD 'konfoosh';

>After database creation, can I change them afterwards?

As sysdba, backup the database using gbak.

Take the fbk file somewhere else and restore it using the -c switch and the
new owner's username and password:

GBAK -c 'D:\BACKUPS\SOMETHING.FBK' 'D:\NEWDATA\SOMETHING.FDB' -PAGE_SIZE
8192 -user 'FRED' -password 'konfoosh';

/heLen