List granted access for a group or a user

Henrik
New Contributor III

Is there any way where I can see what access a group or a user have been given to objects (Tables, views, catalogs etc.)?

I noticed that we have the following information_schema tables:

  • catalog_privileges
  • routine_privileges
  • table_privileges
  • schema_privileges
  • volume_privileges

All very helpfull, but i'm missing an overview for what views a group or a user can select.

So how do I get this overview of rights for a group or user?