Subject Re: [firebird-support] Changing Table Owner
Author Martijn Tonies
Hi Artur,

> I need to change the Table owner in all database tables.
> Can someone point me out how I can do this? I know that the change should
> somewere at RDB$USER_PRIVILEGES, but I'm a little afraid that this will
> be enough.
> Can someone tell correct way to do it? I will need to disable some system
> triggers to do it, and I'm a little afraid that the triggers could be
> not onling to prevent the change....
> "By-The-Book" alternative option is create a backup metadata only, create
> new database from it, and pump the data back. No funny work. :-)
> Any more options available?

Contact Thomas Steinmaurer - he created the "FBOwnerMigrator" tool.

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions