I create database with tables, stored procedures with the user SYSDBA
I backed up the database and then recreated the database using gbak
(as suggested below)
I can open the database with the new user name but I still cannot
execute my stored procedures and update data in tables as the table
and stored procedure owners are still SYSDBA.
Is there a way I can modify this?

Thanks in advance

Nina
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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