Determining what a user can access

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Determining what a user can access
Date: 2003-12-10 04:10:43
Message-ID: 20031210041043.GB18199@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was just trying to find a query what would determine, given a username,
what tables they can see and what permissions they have on those tables.
Obviously this would only work for superusers, but does anyone have any
ideas?

A while ago someone tried using the like operator, would that be the best
approach?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> (... have gone from d-i being barely usable even by its developers
> anywhere, to being about 20% done. Sweet. And the last 80% usually takes
> 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seamus Thomas Carroll 2003-12-10 06:06:24 initdb reporting error.
Previous Message Gaetano Mendola 2003-12-10 01:21:53 Re: add column sillyness