Re: List user who have access to schema

yes ... how can i pass variable * to the function has_schema_privilege(*, 'schema-of-interest', 'usage'); Thanks! On Thu, Aug 2, 2018 at 12:58 PM, Tom Lane wrote: > Suresh Raja writes: > > I'm looking for query which can list all users who have

List user who have access to schema

Hi All: I'm looking for query which can list all users who have access to a particular schema. The user may be granted role, which is turn may have access to the schema. If the schema name is sch1, grant select on table sch1.tab1 to role_ro; grant ALL on table sch1.tab1 to role_rw; grant role_r