Hi all,
I'm trying to see what privileges are assigned to tables/views for
specific group or user. But when I run the query -
select c.table_name,c.grantee,c.privilege_type from
information_schema.role_table_grants c;
it only returns the result for group that current user belongs to.
Is it possible to query from a specific user to see ALL users and
their privileges?
thanks.
Marcus