Subject Re: Can users have the ability to Backup & Restore with gbak
--- In, Helen Borrie <helebor@t...>
> At 08:42 AM 14/09/2004 +0000, you wrote:
> >--- In, Helen Borrie
> >wrote:
> > > At 04:12 PM 14/09/2004 +1000, you wrote:
> > > >Can any user have the ability to use gbak to back up and
> >firebird
> > > >databases ??? so far only my sysdba and password account is
> >capable, how
> > > >can one make a new user capable of this sort of power over a DB
> >they
> > > >created ???
> > >
> > > If the user created the database, then that user is the Owner
> >can back
> > > it up. (Side-note: though the Owner has the power of life and
> >death over
> > > the database as a whole, it doesn't get automatic privs to
> >within
> > > the database that are owned by other users...)
> > >
> > > ./heLen
> >
> >Thanks for the tip H, but i believe the user created the DB in the
> >first place (i will certainly double check this fact) and if so,
> >else would stop the user from backing it up...???
> 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.