dropRowAccessPolicyOnView

Last updated: January 27, 2026

Removes a row access policy from a view in Snowflake. After removing the policy from all views and tables, the policy itself 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
`viewCatalogName`	String	Name of the catalog (database) containing the view	No
`viewSchemaName`	String	Name of the schema containing the view	No
`viewName`	String	Name of the view to remove the policy from	Yes
`policyCatalogName`	String	Name of the catalog containing the policy	No
`policySchemaName`	String	Name of the schema containing the policy	No
`policyName`	String	Name of the row access policy to remove	Yes
`ifExists`	Boolean	Remove policy only if view 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 policy from view -->
    <changeSet id="drop-policy-from-view" author="examples">
        <pro-snowflake:dropRowAccessPolicyOnView
                viewName="EMPLOYEE_SUMMARY_VIEW"
                policyName="DEPARTMENT_ACCESS_POLICY"/>
    </changeSet>

    <!-- Drop policy with IF EXISTS -->
    <changeSet id="drop-policy-from-view-if-exists" author="examples">
        <pro-snowflake:dropRowAccessPolicyOnView
                viewName="SALES_REPORT_VIEW"
                policyName="TENANT_ISOLATION_POLICY"
                ifExists="true"/>
    </changeSet>

    <!-- Drop cross-schema policy from view -->
    <changeSet id="drop-policy-cross-schema" author="examples">
        <pro-snowflake:dropRowAccessPolicyOnView
                viewName="FINANCE_DASHBOARD_VIEW"
                policySchemaName="SECURITY"
                policyName="FINANCE_ACCESS_POLICY"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-policy-from-view",
        "author": "examples",
        "changes": [
          {
            "dropRowAccessPolicyOnView": {
              "viewName": "EMPLOYEE_SUMMARY_VIEW",
              "policyName": "DEPARTMENT_ACCESS_POLICY"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-policy-from-view-if-exists",
        "author": "examples",
        "changes": [
          {
            "dropRowAccessPolicyOnView": {
              "viewName": "SALES_REPORT_VIEW",
              "policyName": "TENANT_ISOLATION_POLICY",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-policy-cross-schema",
        "author": "examples",
        "changes": [
          {
            "dropRowAccessPolicyOnView": {
              "viewName": "FINANCE_DASHBOARD_VIEW",
              "policySchemaName": "SECURITY",
              "policyName": "FINANCE_ACCESS_POLICY"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic drop policy from view
  - changeSet:
      id: drop-policy-from-view
      author: examples
      changes:
        - dropRowAccessPolicyOnView:
            viewName: EMPLOYEE_SUMMARY_VIEW
            policyName: DEPARTMENT_ACCESS_POLICY

  # Drop policy with IF EXISTS
  - changeSet:
      id: drop-policy-from-view-if-exists
      author: examples
      changes:
        - dropRowAccessPolicyOnView:
            viewName: SALES_REPORT_VIEW
            policyName: TENANT_ISOLATION_POLICY
            ifExists: true

  # Drop cross-schema policy from view
  - changeSet:
      id: drop-policy-cross-schema
      author: examples
      changes:
        - dropRowAccessPolicyOnView:
            viewName: FINANCE_DASHBOARD_VIEW
            policySchemaName: SECURITY
            policyName: FINANCE_ACCESS_POLICY

--liquibase formatted sql

--changeset examples:basic-drop-policy-from-view
-- Basic drop policy from view
ALTER VIEW PUBLIC.EMPLOYEE_SUMMARY_VIEW DROP ROW ACCESS POLICY PUBLIC.DEPARTMENT_ACCESS_POLICY;

--changeset examples:drop-policy-with-if-exists
-- Drop policy with IF EXISTS
ALTER VIEW IF EXISTS PUBLIC.SALES_REPORT_VIEW DROP ROW ACCESS POLICY PUBLIC.TENANT_ISOLATION_POLICY;

--changeset examples:drop-cross-schema-policy-from-view
-- Drop cross-schema policy from view
ALTER VIEW PUBLIC.FINANCE_DASHBOARD_VIEW DROP ROW ACCESS POLICY SECURITY.FINANCE_ACCESS_POLICY;

<?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 policy from view -->
    <changeSet id="drop-policy-from-view" author="examples">
        <pro-snowflake:dropRowAccessPolicyOnView
                viewName="EMPLOYEE_SUMMARY_VIEW"
                policyName="DEPARTMENT_ACCESS_POLICY"/>
    </changeSet>

    <!-- Drop policy with IF EXISTS -->
    <changeSet id="drop-policy-from-view-if-exists" author="examples">
        <pro-snowflake:dropRowAccessPolicyOnView
                viewName="SALES_REPORT_VIEW"
                policyName="TENANT_ISOLATION_POLICY"
                ifExists="true"/>
    </changeSet>

    <!-- Drop cross-schema policy from view -->
    <changeSet id="drop-policy-cross-schema" author="examples">
        <pro-snowflake:dropRowAccessPolicyOnView
                viewName="FINANCE_DASHBOARD_VIEW"
                policySchemaName="SECURITY"
                policyName="FINANCE_ACCESS_POLICY"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "drop-policy-from-view",
        "author": "examples",
        "changes": [
          {
            "dropRowAccessPolicyOnView": {
              "viewName": "EMPLOYEE_SUMMARY_VIEW",
              "policyName": "DEPARTMENT_ACCESS_POLICY"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-policy-from-view-if-exists",
        "author": "examples",
        "changes": [
          {
            "dropRowAccessPolicyOnView": {
              "viewName": "SALES_REPORT_VIEW",
              "policyName": "TENANT_ISOLATION_POLICY",
              "ifExists": true
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "drop-policy-cross-schema",
        "author": "examples",
        "changes": [
          {
            "dropRowAccessPolicyOnView": {
              "viewName": "FINANCE_DASHBOARD_VIEW",
              "policySchemaName": "SECURITY",
              "policyName": "FINANCE_ACCESS_POLICY"
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  # Basic drop policy from view
  - changeSet:
      id: drop-policy-from-view
      author: examples
      changes:
        - dropRowAccessPolicyOnView:
            viewName: EMPLOYEE_SUMMARY_VIEW
            policyName: DEPARTMENT_ACCESS_POLICY

  # Drop policy with IF EXISTS
  - changeSet:
      id: drop-policy-from-view-if-exists
      author: examples
      changes:
        - dropRowAccessPolicyOnView:
            viewName: SALES_REPORT_VIEW
            policyName: TENANT_ISOLATION_POLICY
            ifExists: true

  # Drop cross-schema policy from view
  - changeSet:
      id: drop-policy-cross-schema
      author: examples
      changes:
        - dropRowAccessPolicyOnView:
            viewName: FINANCE_DASHBOARD_VIEW
            policySchemaName: SECURITY
            policyName: FINANCE_ACCESS_POLICY

--liquibase formatted sql

--changeset examples:basic-drop-policy-from-view
-- Basic drop policy from view
ALTER VIEW PUBLIC.EMPLOYEE_SUMMARY_VIEW DROP ROW ACCESS POLICY PUBLIC.DEPARTMENT_ACCESS_POLICY;

--changeset examples:drop-policy-with-if-exists
-- Drop policy with IF EXISTS
ALTER VIEW IF EXISTS PUBLIC.SALES_REPORT_VIEW DROP ROW ACCESS POLICY PUBLIC.TENANT_ISOLATION_POLICY;

--changeset examples:drop-cross-schema-policy-from-view
-- Drop cross-schema policy from view
ALTER VIEW PUBLIC.FINANCE_DASHBOARD_VIEW DROP ROW ACCESS POLICY SECURITY.FINANCE_ACCESS_POLICY;

dropRowAccessPolicyOnView

Available attributes

XML

JSON

YAML

SQL

More like this