Re: Database User

On Wed, Jun 20, 2007 at 11:59:11AM -0400, Carol Walter wrote:
> I hope this is a simple request, but I'm a relative newby and I don't
> know my way around the system tables yet. My user wants to know who
> has privs to a specific database. How can I give her this info.

You could use the access privilege functions documented in
http://www.postgresql.org/docs/8.1/interactive/functions-info.html.
Alternatively, the datacl column in the pg_database table might help
you.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The plural of anecdote is not data.
--Roger Brinner