> > 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 http://sourceforge.net/projects/fbexport/ should help you
> extract/re-import your data. I'm pretty sure you can also backup/restore

to

> 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
Server
Upscene Productions
http://www.upscene.com