dropRowAccessPolicy

Drops an existing row access policy from Snowflake. The policy must not be attached to any tables or views before it can be dropped.

Note: This change type does not support automatic rollback or database inspection features (snapshot, diff, diff-changelog, and generate-changelog commands).

Available attributes

Attribute

Type

Description

Required

catalogName

String

Name of the catalog (database) containing the policy

No

schemaName

String

Name of the schema containing the policy

No

policyName

String

Name of the row access policy to drop

Yes

ifExists

Boolean

Only drop if the policy exists using IF EXISTS

No

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  xmlns:pro-snowflake="http://www.liquibase.org/xml/ns/pro-snowflake"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/pro-snowflake
        http://www.liquibase.org/xml/ns/pro-snowflake/liquibase-pro-snowflake-latest.xsd">
  <!-- Basic drop -->
  <changeSet id="drop-row-access-policy-basic" author="examples">
    <pro-snowflake:dropRowAccessPolicy policyName="TEMPORARY_POLICY"/>
  </changeSet>
  <!-- Drop with IF EXISTS -->
  <changeSet id="drop-row-access-policy-if-exists" author="examples">
    <pro-snowflake:dropRowAccessPolicy
                policyName="OLD_ACCESS_POLICY"
                ifExists="true"/>
  </changeSet>
</databaseChangeLog>