Table Ownership

Database
Enthusiast

Table Ownership

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.

1 REPLY
Teradata Employee

Re: Table Ownership

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.