Subject | Re: table owners |
---|---|
Author | Fabrice Aeschbacher |
Post date | 2001-07-17T11:31:23Z |
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
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