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
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.