

 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\$1DEFAULT\$1PRIVILEGES
<a name="r_SVV_DEFAULT_PRIVILEGES"></a>

 Use SVV\$1DEFAULT\$1PRIVILEGES to view the default privileges that a user has access to in an Amazon Redshift cluster. 

 SVV\$1DEFAULT\$1PRIVILEGES is visible to the following users:
+ Superusers
+ Users with the ACCESS SYSTEM TABLE permission

Other users can only see default permissions granted to them.

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

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

## Sample query
<a name="r_SVV_DEFAULT_PRIVILEGES-sample-query"></a>

 The following example returns the output for SVV\$1DEFAULT\$1PRIVILEGES. 

```
SELECT * from svv_default_privileges;

 schema_name |    object_type    | owner_id | owner_name | owner_type | privilege_type | grantee_id | grantee_name | grantee_type | admin_option
-------------+-------------------+--------- +------------+------------+----------------+------------+--------------+--------------+-------------+
   public    |     RELATION      |    106   |     u1     |    user    |     UPDATE     |     107    |      u2      |     user     |      f      |
   public    |     RELATION      |    106   |     u1     |    user    |     SELECT     |     107    |      u2      |     user     |      f      |
```