Unable to update schema - must be owner of table

General Discussion
1

Hi,

I’m using Liquibase for the first time to update a PostgreSQL table schema. The update command fails due to this error “Exception Primary Reason: ERROR: must be owner of table …”, the user has all permissions but is not the table owner as i have more than one user with read/write permissions for that table.

Is is really required for the user to be the table owner?

Thank you for your help

Env:

  • Spring Boot: v2.7.13
  • Liquibase: 4.25.1
2

This is a postgres permission issue, not related to Liquibase.

If you connect to the database manually as the same user and try running the same sql via psql, you’ll get the same error.

You need to review the privileges of the user you are connecting to postgres as.