Get user roles

[GaryShelton]

How can I get the user's roles? I need to adjust the Select statements, as well as visibility properties for Vcl Form components for MariaDB depending on the users roles. MariaDB does not allow Select * when not all columns have select privileges. Or is there another way this is usually handled?

[ViktorV]

You can find the necessary information on getting get user roles by the link https://dev.mysql.com/doc/refman/8.0/en ... rants.html

[GaryShelton]

Sorry, question was not clear enough. Yes I can use the Show Grants statement, but what I am looking for is a way to do this in Delphi code. Something like if User.HasRole('Financial') then change select statement and set visibility for controls based on return value

[ViktorV]

MyDAC components don't have those properties. You may try implementing the required functionality yourself, for example, by sending requests to MySQL server and handling the response.