How do I generate GRANTs in Liquibase?

Question

I have an existing DB2 (10.5.0) project I am migrating to Liquibase (3.4.1), and I want to export my existing schema.

However it is skipping the GRANTs. How do I get those?

Also when I create new tables, indices etc, how can I add GRANT to a role within my changeLogFile.xml?

Answer 1

Liquibase does not currently support GRANTs as they are a database-specific concept. You would need to write the GRANT statements using the <sql> or <sqlFile> change types.