YugabyteDB includes a number of [pre-bundled PostgreSQL extensions](../../../additional-features/pg-extensions/), tested to work with YSQL, that you can use to extend the functionality of your database.

{{< note title="Extensions must be pre-bundled" >}}

YugabyteDB Aeon only supports extensions that are pre-bundled in YugabyteDB. You cannot install new extensions in YugabyteDB Aeon. Refer to [PostgreSQL extensions](../../../additional-features/pg-extensions/) for the list of pre-bundled extensions.

{{< /note >}}

## Loading extensions

Before using an extension, you must load it in the database using the [CREATE EXTENSION](../../../api/ysql/the-sql-language/statements/ddl_create_extension/) command. For example:

```sql
CREATE EXTENSION fuzzystrmatch;
```

## Required privileges

In YugabyteDB Aeon, extensions can only be loaded by users that are a member of the `yb_extension` role. All `yb_superuser` users, including the default database admin user, are members of `yb_extension`.

Use the `GRANT` statement to assign the role to users. For example, to grant the `yb_extension` role to `user`, use the following command:

```sql
yugabyte=# GRANT yb_extension TO user;
```

For more information on roles in YugabyteDB Aeon, refer to [Database authorization in YugabyteDB Aeon clusters](../../cloud-secure-clusters/cloud-users/).

## Learn more

- [PostgreSQL extensions](../../../additional-features/pg-extensions/)
- [Database authorization in YugabyteDB Aeon clusters](../../cloud-secure-clusters/cloud-users/)
- [Manage Users and Roles in YSQL](../../../secure/authorization/create-roles/)