Subject Re: [firebird-support] Re: Can users have the ability to Backup & Restore with gbak
Author Helen Borrie
At 08:42 AM 14/09/2004 +0000, you wrote:
>--- In, Helen Borrie <helebor@t...>
> > At 04:12 PM 14/09/2004 +1000, you wrote:
> > >Can any user have the ability to use gbak to back up and restore
> > >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
> > >created ???
> >
> > If the user created the database, then that user is the Owner and
>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 objects
> > 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, what
>else would stop the user from backing it up...???

Nothing, if we are both talking about a database user...unless, of course,
that user created the database with a different USER in the CREATE statement.

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 HELEN
created the database, user 'craig' owns it.