> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/set-default-role.md).

# SET DEFAULT ROLE

## Syntax

```bnf
SET DEFAULT ROLE { role | NONE } [ FOR user@host ]
```

## Description

The `SET DEFAULT ROLE` statement sets a **default** [**role**](/docs/server/security/user-account-management/roles.md) for a specified (or current) user. A default role is automatically enabled when a user connects (an implicit [SET ROLE](/docs/server/reference/sql-statements/account-management-sql-statements/set-role.md) statement is executed immediately after a connection is established).

To be able to set a role as a default, the role must already have been granted to that user, and one needs the privileges to enable this role (if you cannot do `SET ROLE X`, you won't be able to do `SET DEFAULT ROLE X`). To set a default role for another user one needs to have write access to the `mysql` database.

To remove a user's default role, use `SET DEFAULT ROLE NONE [ FOR user@host ]`. The record of the default role is not removed if the role is [dropped](/docs/server/reference/sql-statements/account-management-sql-statements/drop-role.md) or [revoked](/docs/server/reference/sql-statements/account-management-sql-statements/revoke.md#roles), so if the role is subsequently re-created or granted, it will again be the user's default role.

The default role is stored in the `default_role` column in the [mysql.user](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-user-table.md) table/view, as well as in the [Information Schema APPLICABLE\_ROLES table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-applicable_roles-table.md), so these can be viewed to see which role has been assigned to a user as the default.

## Examples

Setting a default role for the current user:

```sql
SET DEFAULT ROLE journalist;
```

Removing a default role from the current user:

```sql
SET DEFAULT ROLE NONE;
```

Setting a default role for another user. The role has to have been granted to the user before it can be set as default:

```sql
CREATE ROLE journalist;
CREATE USER taniel;

SET DEFAULT ROLE journalist FOR taniel;
ERROR 1959 (OP000): Invalid role specification `journalist`

GRANT journalist TO taniel;
SET DEFAULT ROLE journalist FOR taniel;
```

Viewing mysql.user:

```sql
SELECT * FROM mysql.user WHERE user='taniel'\G
```

```
*************************** 1. row ***************************
                  Host: %
                  User: taniel
...
               is_role: N
          default_role: journalist
...
```

Removing a default role for another user

```sql
SET DEFAULT ROLE NONE FOR taniel;
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}