> 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

Yes, ask Thomas Steinmaurer (he's on this list) for his ownership changer
application. works a treat
Alan