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

New Topic

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 12:19PM

Hello Georgi,

Aha, SHOW CREATE USER lists the default role(s)! So the info >is< available.

Why isn't this stuff surfaced through the data dictionary?

For tool developers to have to parse SQL statements in order to get meta data info is... 'annoying' to say the least.

With regards,

Martijn Tonies
Upscene Productions

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

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

1119

Martijn Tonies

October 31, 2018 08:49AM

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

423

Peter Brawley

October 31, 2018 09:50AM

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

446

Martijn Tonies

October 31, 2018 10:17AM

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

476

Peter Brawley

October 31, 2018 10:39AM

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

450

Martijn Tonies

October 31, 2018 10:54AM

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

435

Georgi Kodinov

October 31, 2018 11:26AM

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

494

Martijn Tonies

October 31, 2018 12:19PM

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

442

Georgi Kodinov

November 01, 2018 01:29AM

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

440

Martijn Tonies

November 01, 2018 02:27AM

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

461

Peter Brawley

October 31, 2018 08:15PM

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.