Subject Re: [firebird-support] Re: Can users have the ability to Backup & Restore with gbak
Author Helen Borrie
At 10:47 AM 14/09/2004 +0000, you wrote:

> > Nothing, if we are both talking about a database user...unless, of
> > that user created the database with a different USER in the CREATE
> >
> > For example, if I log into isql as user HELEN and I do
> > SQL> create database '/data/helensdb.fdb' user 'craig'
>password 'fw54rtyU'
> > page_size 8192;
> >
> > Then 'craig' will be the Owner, not HELEN. So, even though user
> > created the database, user 'craig' owns it.
> >
> > ./heLen
>i c about your comment, and yes if i do this then i can create a DB,
>SQL> create database 'localhost:c:\db1.fdb' user 'sysdba'
>password 'materkey' page_size 8192;
>but....if i add a user through GSEC to the security db and try to do
>it with the new user as per the following...
>SQL> create database 'localhost:c:\db2.fdb' user 'craig'
>password '12345' page_size 8192;
>i get the following error, similar to when i am trying to gbak a DB
>Statement Failed SQL code -902
>Your user name and password are not defined. Ask your administrator
>to set up a firebird login.
>But Hey !!! didnt i add the new user to the security.fdb before even
>attempting why is the user not found ! and thereby cannot
>create a DB and finally back it up...this is my
>appears nobody but the sysdba can do anything, i assume you dont have
>to go to all the trouble of adding privaledges and roles to the
>firebird security database before i can have a simple user
>create/backup/restore a simple FB-DB.

Hmm.. I did the following:

gsec -add craig -pw verbatim -user sysdba -password ravinmad

isql -u sysdba -password ravinmad
SQL>create database 'l:\data\test\craigsb.fdb'
CON>user 'craig' password 'verbatim'
CON>page_size 8192;
gbak -b l:\data\test\craigsdb.fdb l:\data\test\craigsdb.fbk -user craig
-password verbatim

..and wrote the backup.

isql l:\data\test\craigsdb.fdb -user craig -password verbatim
SQL>drop database;
SQL>show database;
Use CONNECT or CREATE DATABASE to specify a database

So - maybe you got the password wrong?