> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference and syntax for the ALTER NETWORK POLICY command.

# ALTER NETWORK POLICY

## ALTER NETWORK POLICY SET/ADD/REMOVE

Updates the configuration of the existing network policy by specifying its name, a list of internet protocol (IP) addresses to allow or block, and an optional description.

For more information, see [Network policies](/guides/security/network-policies).

### Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY [ IF EXISTS ] <network_policy_name>
    SET [ ALLOWED_IP_LIST = ( '<allowed_ip>', '<allowed_ip>' ... ) ]
        [ BLOCKED_IP_LIST = ( '<blocked_ip>', '<blocked_ip>' ... ) ]
        [ DESCRIPTION = '<description>' ]

ALTER NETWORK POLICY [ IF EXISTS ] <network_policy_name>
    ADD [ ALLOWED_IP_LIST = ( '<allowed_ip>', '<allowed_ip>' ... ) ]
        [ BLOCKED_IP_LIST = ( '<blocked_ip>', '<blocked_ip>' ... ) ]

ALTER NETWORK POLICY [ IF EXISTS ] <network_policy_name>
    REMOVE [ BLOCKED_IP_LIST = ( '<blocked_ip>', '<blocked_ip>' ... ) ]
           [ BLOCKED_IP_LIST = ( '<blocked_ip>', '<blocked_ip>' ... ) ]
```

### Parameters

| Parameter               | Description                                                                                     |
| :---------------------- | :---------------------------------------------------------------------------------------------- |
| `<network_policy_name>` | The name of the network policy to edit.                                                         |
| `<allowed_ip>`          | A comma-separated and quoted list of IP addresses to **allow** in the specified network policy. |
| `<blocked_ip>`          | A comma-separated and quoted list of IP addresses to **block** in the specified network policy. |
| `<description>`         | (Optional) A description for the specified network policy.                                      |

### Examples

**Example**

The following code example modifies the existing network policy 'my\_network\_policy' by replacing its allowed and blocked IP lists with specified values and an updating its description:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY my_network_policy SET ALLOWED_IP_LIST = ('4.5.6.7', '2.4.5.7') BLOCKED_IP_LIST = ('6.7.8.9') DESCRIPTION = 'updated network policy'
```

**Example**

The following code example adds an IP address `192.168.5.1` to the allowed list of the existing network policy `my_network_policy`:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY my_network_policy ADD ALLOWED_IP_LIST = ('192.168.5.1');
```

**Example**

The following code example removes the IP address `6.7.8.9` from the blocked list of the network policy `my_network_policy`:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY my_network_policy REMOVE BLOCKED_IP_LIST = ('6.7.8.9');
```

## ALTER NETWORK POLICY RENAME TO

Renames a network policy.

### Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY <network_policy_name> RENAME TO <new_network_policy_name>
```

### Parameters

| Parameter                   | Description                               |
| :-------------------------- | :---------------------------------------- |
| `<network_policy_name>`     | The name of the network policy to rename. |
| `<new_network_policy_name>` | The new name of the network policy.       |

### Example

The following command will rename the "office" network policy to "office\_branch\_1".

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY "office" RENAME TO "office_branch_1";
```

## ALTER NETWORK POLICY OWNER TO

Changes the owner of a network policy.

You can view the current owner in the `network_policy_owner` column of the `information_schema.network_policies` view.

For more information, see [ownership](/guides/security/ownership).

### Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY <network_policy_name> OWNER TO <identity>
```

### Parameters

| Parameter               | Description                                                                                     |
| :---------------------- | :---------------------------------------------------------------------------------------------- |
| `<network_policy_name>` | The name of the network policy to change the owner of.                                          |
| `<identity>`            | The new owner of the network policy, which can be the name of another login or service account. |

### Example

The following command will set network policy "my\_policy" owner to "[alice@acme.com](mailto:alice@acme.com)".

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ALTER NETWORK POLICY "my_policy" OWNER TO "alice@acme.com";
```