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;


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.

Todd