Subject Re: table owners
Author Fabrice Aeschbacher
Hi Jordi,

Connect as SYSDBA, and try to execute:

UPDATE RDB$RELATIONS
SET RDB$OWNER_NAME = 'NEW_OWNER'
WHERE RDB$RELATION_NAME = 'MY_TABLE'

Not sure this works, but you can try. If not, you'll have to delete
and then re-create the table.

(make a backup before playing with system tables :-)

Regards,
Fabrice

--- In ib-support@y..., Jordi Gálvez <j.galvez@i...> wrote:
> Hi!
>
> How can I change the owner of a table?
>
> Thanks!
>
> Jordi