Subject | Re: [firebird-support] Re: cannot connect to a restored database |
---|---|
Author | Nando Dessena |
Post date | 2004-01-06T17:58:53Z |
Fred,
f> Now I see that all of the table ownerships are wrong. It is
f> interesting that a backup/restore does not preserve ownerships. I
f> suppose that the ability to change table owners is useful, but I
f> would expect the default behavior to be preservation of ownerships.
gbak -r (or -c) creates a brand new database; the owner can only be
the user that gbak is operating with. Otherwise anyone could create a
database on behalf of anyone else.
f> Oh well, one more question. Can I fix the ownerships by updating
f> RDB$RELATIONS?
Frightens me...
Ciao
--
Nando mailto:nandod@...
f> Now I see that all of the table ownerships are wrong. It is
f> interesting that a backup/restore does not preserve ownerships. I
f> suppose that the ability to change table owners is useful, but I
f> would expect the default behavior to be preservation of ownerships.
gbak -r (or -c) creates a brand new database; the owner can only be
the user that gbak is operating with. Otherwise anyone could create a
database on behalf of anyone else.
f> Oh well, one more question. Can I fix the ownerships by updating
f> RDB$RELATIONS?
Frightens me...
Ciao
--
Nando mailto:nandod@...