Hi there,

> 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?

I've answered you privately.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com