Hello .. Can the table ownership can be transferred to another user, without havign to drop and delete or a CREATE TABLE AS, so that the original metadata can be preserved ?? GIVE doesn't seem to help. For example .. Once a table i created by User1, who is no longer working with the employer. The team would prefer to maintain the original creation date etc. Thanks in advance.
The owner of the database containing the table could GRANT ALL on <the-table> WITH GRANT OPTION to <a-different-userID>, and that would accomplish the same thing as far as privileges go.