Liquibase reverted grant after updating PLSQL function (DB - PostgreSQL)

Liquibase Development
1

Hi All,

I am having issue with executing sql script with liquibase.

Every first time executing sql function with liquibase, creates all the required grants for the PLSQL function.

When modify the existing function and rerun script using liquibase, it removes grants.

Please help me in solving this issue.

Thanks,

Irfan

2

Liquibase doesn’t do anything with grants, my guess is that for some reason the database is dropping them. Are you doing drop/creates where you could be doing alter statements?

Nathan