Change table ownership

If you are the owner of the table or have the Alter privilege on tables, you can change the owner of a table without changing any of its data. The new owner must be a current system user.

To change the owner of a table, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE weather OWNER TO jane;

Note: The ALTER TABLE command requires exclusive access to the table before it runs, and waits until it has exclusive access.