Secure 6.0: alterRowAccessPolicyComment

Reference
Version · 6.0
Change Automation Reference

alterRowAccessPolicyComment

Last updated: September 24, 2026

Sets or removes the comment on an existing row access policy in Snowflake.

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 alter	Yes
`ifExists`	Boolean	Only alter if the policy exists using `IF EXISTS`	No
`newComment`	String	New comment text to set*	No
`unsetComment`	Boolean	Remove the existing comment*	No

* Exactly one of newComment or unsetComment must be specified

<?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">

    <!-- Set comment -->
    <changeSet id="policy-set-comment" author="examples">
        <pro-snowflake:alterRowAccessPolicyComment policyName="DEPARTMENT_ACCESS_POLICY">
            <pro-snowflake:newComment>Row-level security for department data access</pro-snowflake:newComment>
        </pro-snowflake:alterRowAccessPolicyComment>
    </changeSet>

    <!-- Set comment with IF EXISTS -->
    <changeSet id="policy-set-comment-if-exists" author="examples">
        <pro-snowflake:alterRowAccessPolicyComment
                policyName="TENANT_ISOLATION_POLICY"
                ifExists="true">
            <pro-snowflake:newComment>Multi-tenant data isolation policy</pro-snowflake:newComment>
        </pro-snowflake:alterRowAccessPolicyComment>
    </changeSet>

    <!-- Unset comment -->
    <changeSet id="policy-unset-comment" author="examples">
        <pro-snowflake:alterRowAccessPolicyComment
                policyName="LEGACY_POLICY"
                unsetComment="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "policy-set-comment",
        "author": "examples",
        "changes": [
          {
            "alterRowAccessPolicyComment": {
              "policyName": "DEPARTMENT_ACCESS_POLICY",
              "newComment": "Row-level security for department data access"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "policy-set-comment-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterRowAccessPolicyComment": {
              "policyName": "TENANT_ISOLATION_POLICY",
              "ifExists": true,
              "newComment": "Multi-tenant data isolation policy"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "policy-unset-comment",
        "author": "examples",
        "changes": [
          {
            "alterRowAccessPolicyComment": {
              "policyName": "LEGACY_POLICY",
              "unsetComment": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Set comment
  - changeSet:
      id: policy-set-comment
      author: examples
      changes:
        - alterRowAccessPolicyComment:
            policyName: DEPARTMENT_ACCESS_POLICY
            newComment: Row-level security for department data access

  #Set comment with IF EXISTS
  - changeSet:
      id: policy-set-comment-if-exists
      author: examples
      changes:
        - alterRowAccessPolicyComment:
            policyName: TENANT_ISOLATION_POLICY
            ifExists: true
            newComment: Multi-tenant data isolation policy

  #Unset comment
  - changeSet:
      id: policy-unset-comment
      author: examples
      changes:
        - alterRowAccessPolicyComment:
            policyName: LEGACY_POLICY
            unsetComment: true

-- Set comment
ALTER ROW ACCESS POLICY PUBLIC.DEPARTMENT_ACCESS_POLICY SET COMMENT = 'Row-level security for department data access';

-- Set comment with IF EXISTS
ALTER ROW ACCESS POLICY IF EXISTS PUBLIC.TENANT_ISOLATION_POLICY SET COMMENT = 'Multi-tenant data isolation policy';

-- Unset comment
ALTER ROW ACCESS POLICY PUBLIC.LEGACY_POLICY UNSET COMMENT;

<?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">

    <!-- Set comment -->
    <changeSet id="policy-set-comment" author="examples">
        <pro-snowflake:alterRowAccessPolicyComment policyName="DEPARTMENT_ACCESS_POLICY">
            <pro-snowflake:newComment>Row-level security for department data access</pro-snowflake:newComment>
        </pro-snowflake:alterRowAccessPolicyComment>
    </changeSet>

    <!-- Set comment with IF EXISTS -->
    <changeSet id="policy-set-comment-if-exists" author="examples">
        <pro-snowflake:alterRowAccessPolicyComment
                policyName="TENANT_ISOLATION_POLICY"
                ifExists="true">
            <pro-snowflake:newComment>Multi-tenant data isolation policy</pro-snowflake:newComment>
        </pro-snowflake:alterRowAccessPolicyComment>
    </changeSet>

    <!-- Unset comment -->
    <changeSet id="policy-unset-comment" author="examples">
        <pro-snowflake:alterRowAccessPolicyComment
                policyName="LEGACY_POLICY"
                unsetComment="true"/>
    </changeSet>

</databaseChangeLog>

{
  "databaseChangeLog": [
    {
      "changeSet": {
        "id": "policy-set-comment",
        "author": "examples",
        "changes": [
          {
            "alterRowAccessPolicyComment": {
              "policyName": "DEPARTMENT_ACCESS_POLICY",
              "newComment": "Row-level security for department data access"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "policy-set-comment-if-exists",
        "author": "examples",
        "changes": [
          {
            "alterRowAccessPolicyComment": {
              "policyName": "TENANT_ISOLATION_POLICY",
              "ifExists": true,
              "newComment": "Multi-tenant data isolation policy"
            }
          }
        ]
      }
    },
    {
      "changeSet": {
        "id": "policy-unset-comment",
        "author": "examples",
        "changes": [
          {
            "alterRowAccessPolicyComment": {
              "policyName": "LEGACY_POLICY",
              "unsetComment": true
            }
          }
        ]
      }
    }
  ]
}

databaseChangeLog:
  #Set comment
  - changeSet:
      id: policy-set-comment
      author: examples
      changes:
        - alterRowAccessPolicyComment:
            policyName: DEPARTMENT_ACCESS_POLICY
            newComment: Row-level security for department data access

  #Set comment with IF EXISTS
  - changeSet:
      id: policy-set-comment-if-exists
      author: examples
      changes:
        - alterRowAccessPolicyComment:
            policyName: TENANT_ISOLATION_POLICY
            ifExists: true
            newComment: Multi-tenant data isolation policy

  #Unset comment
  - changeSet:
      id: policy-unset-comment
      author: examples
      changes:
        - alterRowAccessPolicyComment:
            policyName: LEGACY_POLICY
            unsetComment: true

-- Set comment
ALTER ROW ACCESS POLICY PUBLIC.DEPARTMENT_ACCESS_POLICY SET COMMENT = 'Row-level security for department data access';

-- Set comment with IF EXISTS
ALTER ROW ACCESS POLICY IF EXISTS PUBLIC.TENANT_ISOLATION_POLICY SET COMMENT = 'Multi-tenant data isolation policy';

-- Unset comment
ALTER ROW ACCESS POLICY PUBLIC.LEGACY_POLICY UNSET COMMENT;

PreviousAlterRowAccessPolicyBody NextAlterRowAccessPolicyTags

alterRowAccessPolicyComment

Available attributes

XML

JSON

YAML

SQL

More like this