MySQL Forums
Forum List  »  Security

Re: In MySQL 8, how do you know what the 'default role(s)' is for a user?
Posted by: Martijn Tonies
Date: October 31, 2018 10:17AM

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

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.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.