>>logged in as another user. The trap here, of course, is that
>
> changing the
>
>>owner of the database does not change the ownership of the objects
>
> inside
>
>>the database. To do the right thing, you will need to rebuild the
>
> database
>
>>from scratch, i.e. from script, while logged in as the user which
>
> you want
>
>>to be the owner.
>
>
> Can i use a 'magic' to achieve this by changing some system tables?
> For example:
>
> update rdb$relations set
> rdb$owner_name = 'SOME_USER';
>
> update rdb$procedures set
> rdb$owner_name = 'SOME_USER';
>
> update rdb$roles set
> rdb$owner_name = 'SOME_USER';
>
> I have many customers using my application and rebuilding each
> database from scratch and pump data is not an option for me...

It's more involved than the things shown above.

Send me an email requesting the download URL for a tool called
"FBOwnerMigrator".


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