Subject Re: [firebird-support] Changing ownership of objects in a database
Author Thomas Steinmaurer
Hi Steffen,

>>>Does anyone know how to change the ownership of all the
>>>tables/procedure/etc in a database?
>>
>>I've answered you privately.
>
>
> Hm.
> Would be more polite to answer in the list, as there are propably more users
> facing the same problem / question.

Alan has referred to a tool we have to migrate ownership by updating
system tables directly. This has been researched carefully and has
worked for many people so far.

People can request a download link for this tool (FBOwnerMigrator) by
sending a private email. Why is it not available as public download?
Well, because it manipulates system tables directly. ;-)

> I act as proof of concept in this case.

If you are interested, please send me an email.


--
HTH,
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