While trying to change ownership of a couple tables or hypertables, it is important to note that ALTER TABLE is blocked due to super use credentials on Timescale Cloud.

You will see the following:

ERROR: permission denied for schema _timescaledb_internal

Instead, we recommend using the REASSIGN command:

REASSIGN OWNED BY current_role TO desired_role
Did this answer your question?