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

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?