Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# SVV\$1ATTACHED\$1MASKING\$1POLICY
<a name="r_SVV_ATTACHED_MASKING_POLICY"></a>

Use SVV\$1ATTACHED\$1MASKING\$1POLICY to view all the relations and roles/users with policies attached on the currently connected database. 

Only superusers and users with the [https://docs.aws.amazon.com/redshift/latest/dg/r_roles-default.html](https://docs.aws.amazon.com/redshift/latest/dg/r_roles-default.html) role can view SVV\$1ATTACHED\$1MASKING\$1POLICY. Regular users will see 0 rows.

## Table columns
<a name="r_SVV_ATTACHED_MASKING_POLICY-table-columns"></a>

[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/redshift/latest/dg/r_SVV_ATTACHED_MASKING_POLICY.html)

## Internal functions
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions"></a>

SVV\$1ATTACHED\$1MASKING\$1POLICY supports the following internal functions: 

### mask\$1get\$1policy\$1for\$1role\$1on\$1column
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions-get-pol-role"></a>

Get the highest priority policy that applies to a given column/role pair.

#### Syntax
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions-get-pol-role-syntax"></a>

```
mask_get_policy_for_role_on_column 
                        (relschema, 
                        relname, 
                        colname, 
                        rolename);
```

#### Parameters
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions-get-pol-role-parameters"></a>

 *relschema*   
The name of the schema the policy is in.

 *relname*   
The name of the table the policy is in.

 *colname*   
The name of the column the policy is attached to.

 *rolename*   
The name of the role the policy is attached to.

### mask\$1get\$1policy\$1for\$1user\$1on\$1column
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions-get-pol-user"></a>

Get the highest priority policy that applies to a given column/user pair.

#### Syntax
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions-get-pol-user-syntax"></a>

```
mask_get_policy_for_user_on_column 
                        (relschema, 
                        relname, 
                        colname, 
                        username);
```

#### Parameters
<a name="r_SVV_ATTACHED_MASKING_POLICY-internal-functions-get-pol-user-parameters"></a>

 *relschema*   
The name of the schema the policy is in.

 *relname*   
The name of the table the policy is in.

 *colname*   
The name of the column the policy is attached to.

 *rolename*   
The name of the user the policy is attached to.