Re: In MySQL 8, how do you know what the 'default role(s)' is for a user?

[Martijn Tonies]

Hello Bradley,

Yes, I know. There's also some info in mysql.role_edges - however, none of this lists the default role(s).

Given that you can modify the current effective privileges with a SET ROLE statement, I wonder how you can see which roles are default and which aren't.

Also, using SHOW GRANTS requires parsing (reading) the results in order to understand the granted privileges or roles. I can't find a data dictionary table that lists this properly. Why?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.



Edited 1 time(s). Last edit at 10/31/2018 10:20AM by Martijn Tonies.