Subject Re: [firebird-support] Re: SYSDBA
Author Martijn Tonies
> > So if I have to recreate all my tables under
> > this other DBA equivalent user, how do I export the data from
> > the old db and import it into the new?
> Take a look at should help you
> extract/re-import your data. I'm pretty sure you can also backup/restore
> change the owner of the database.

However, the "owner of the database" does not have to be the same
as the "owner of a table". And only the owner of a table can modify
the table metadata.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions