I am having a difficult time finding the underlying query that is executed when we do e.g. show grants for ‘dba_user’@’%’;
Is the result of that query only showing privileges specifically granted to that user? Or if the user is in a group that has a role that has privileges, will those role-granted privileges also be displayed?
Relatedly, could the results of this query depend on what node you are connected to?