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

and a great tool it is too..! I use it not infrequently.
thanks Thomas
Alan