Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
- There is WITH ADMIN option for creating the role, but without an example of usage on KB. Existing example on the same page is missing some context/explanation of usage. I think that it would be also good and descriptive to have on one place what is happening after creating the role/s with mysql.user, information_schema.applicable_roles, mysql.roles_mapping.
- CREATE ROLE is saying that PUBLIC and NONE cannot be used as role names, while SET ROLE is using NONE to unset the role. Some connection should be done between pages
- I found in code that the role is invalid if it has PUBLIC keyword, but haven't found any example of usage of PUBLIC, think should be covered more.