In MySQL 8.0, how does one recognize roles?

"Martijn Tonies \(Upscene Productions\)" <[email protected]> Tue, 9 Jan 2018 12:42:26 +0100

Newsgroups	gmane.comp.db.mysql.general
Message-ID	<3F1CB390F3D645C5B9365A50FE6A0DAA@MARTIJNWS>

Hi,

In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users

But how does one distinguish between roles and users?

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.