> I created the majority of my tables as a certain user. Other tables
> were created as SYSDBA.
>
> Is it safe to change the owner of an object by:
>
> Log in as SYSDBA and process the following:
>
> Update RDB$RELATIONS
> Set OWNER_NAME = NEWOWNER
> Where RDB$RELATION_NAME = OBJECTNAME;

There is a bit more involved.

> Or is there another way to change the owner. I don't want to have to
> create temporary tables, transfer data, drop existing table, re-
> create table, copy data back, etc. This is too much work because
> there are so many dependancies on the tables that have to be removed
> before I can drop the table.

We have a tool that allows you to migrate a database with several object
owners to a given user. The download is not available for the public.

Send an email to:

t . steinmaurer @ upscene . com

And request the download link.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com