List granted access for a group or a user
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2024 05:52 AM
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?