Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.1.1
-
Component/s: None
-
Labels:None
Description
Syntax variants (which ones we'll do?):
CREATE USER xxx DEFAULT ROLE yyy; |
ALTER USER xxx DEFAULT ROLE yyy; |
SET DEFAULT ROLE yyy; |
SET DEFAULT ROLE yyy [ FOR xxx ]; |
When a default role is set, the server implicitly runs SET ROLE yyy for every new connection (or after a COM_CHANGE_USER for a user xxx).
The default role is stored in a new column in the mysql.user table.
Attachments
Issue Links
- relates to
-
MDEV-4397 Roles
-
- Closed
-
- links to