How can we help you today? How can we help you today?

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

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
vshclover
0

Comments

2 comments

Sort by
  • DanC
    Hi @vshclover

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

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

Add comment

Please sign in to leave a comment.