In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

"Martijn Tonies \(Upscene Productions\)" <[email protected]> Tue, 30 Oct 2018 09:45:52 +0100

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

------=_NextPart_000_0069_01D47035.58BA02B0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi there,

In MySQL 8, how can you figure out if an entry in the mysql.user table =
is a role or a user?

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.
------=_NextPart_000_0069_01D47035.58BA02B0--