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

Regards,

Fabiano.