--- In ib-support@y..., "Fabrice Aeschbacher"
<fabrice.aeschbacher@k...> wrote:

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

Hello,

has someone seen this working?

I mistakenly created the tables as SYSDBA and now want to convert the
owner to the standard user.

Best Regards
Bernhard