What user permissions are required to use Liquibase with my database?

Applies to

• Liquibase Secure
• Liquibase Open Source (Community)

Question

What user permissions are required to use Liquibase with my database?

Answer

The permissions required for the connecting user for Liquibase focus on the Liquibase tracking tables (DATABASECHANGELOG, DATABASECHANGELOGLOCK, and DATABASECHANGELOGHISTORY) and the database inspection commands.
 
For Liquibase tracking tables, the connecting user needs to be able to:

• Create tables
• Insert into tables
• Delete from tables
• Update tables

 
For the database inspection commands, the connecting user needs to be able to read all metadata.
 
All other permissions will depend on the changes you'd like to allow on the database.