--- In firebird-support@yahoogroups.com, Nando Dessena <nandod@d...>
wrote:

> 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@d...

Nando,
If my database contains 50 tables owned by 'owner1' and 100 tables
owned by 'owner2' and 75 tables owned by 'owner3', etc - how can I
backup/restore so that the tables all have their original owners?
If this is not possible with gbak, it is useless for disaster
recovery.
I very much appreciate your patience with me on this. :-)

Thanks
Fred