Subject | Re: [firebird-support] Changing Table Owner |
---|---|
Author | Martijn Tonies |
Post date | 2003-08-23T17:53:56Z |
Hi Artur,
With regards,
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com
> I need to change the Table owner in all database tables.be
>
> 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 willnot
> be enough.there
>
> 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....a
>
> "By-The-Book" alternative option is create a backup metadata only, create
> new database from it, and pump the data back. No funny work. :-)Contact Thomas Steinmaurer - he created the "FBOwnerMigrator" tool.
>
> Any more options available?
With regards,
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com