Hi!

Does anyone know how to change the ownership of all the
tables/procedure/etc in a database?

Using firebird 1.5, and various front-end applications written in
Delphi 5.

We have a load of existing databases which have all been created by
SYSDBA, but I'd like to give a different user rights to change the
METADATA, do backups/restores etc.

I've read that you can do a backup as the original user and then a
restore as the new user, but this hasn't worked for me.

The only sure method I've found is to create a new blank database as
the new owner, and write a program to shuffle the data across. Some
of the databases are very large though and this takes too much time.

Any suggestions?

Thanks