How can i make flyway ignore permissions when it is creating the object files under schema-model

vshclover

Flyway creates sql object files for me with all the permissions related DDL ('GRANT SELECT', 'GRANT EXECUTE' etc.) How can i avoid it ? I looked thru the options in the Filter.scpf. but could not identify the one responsible for this. 

For some reason I don't see Comparison Options and Data Options on the Sattic Data & Comparisons popup.  ??? i see it in the documentation. 

tried manually setting Filter.scpf with false in this tag, but did not help - 

<SecurityPolicy version="1">

        <Include>False</Include>

        <Expression>TRUE</Expression>

</SecurityPolicy>

Thank you

DanC

Hi @vshclover

Can I ask what type of database engine you're using within Flyway Desktop?

vshclover

i installed the new flyway version and now see Comparison Options and Data Options on the Static Data & Comparisons popup. all set