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
be
> somewere at RDB$USER_PRIVILEGES, but I'm a little afraid that this will
not
> 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
there
> not onling to prevent the change....
>
> "By-The-Book" alternative option is create a backup metadata only, create
a
> 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
http://www.upscene.com