Is there a system view in Postgres where I can see which users/roles have "grant usage" and on which schema?

CodePudding user response：

The grants are stored in ACLs (=Access Control Lists) for each schema. You can view them by looking a pg_namespace

select nspname, nspacl 
from pg_namespace

The format of the acl is explained in the manual