The Ultimate Guide to High Availability with MariaDB

SET DEFAULT ROLE

You are viewing an old version of this article. View the current version here.
MariaDB starting with 10.1.1

Default role was implemented in MariaDB 10.1.1.

Contents

  1. Syntax
  2. Description

Syntax

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

Description

The SET DEFAULT ROLE statement sets a *default role* for a specified (or current) user. A default role is automatically enabled when a user connects (an implicit SET ROLE statement is executed immediately after a connection is established).

To be able to set a role as a default, one needs enough 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 some other user one needs to have write access to the mysql database.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.