pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database User
2+ messages / 2 participants
[nested] [flat]

* Database User
@ 2007-06-20 15:59 Carol Walter <walterc@indiana.edu>
  2007-06-20 18:09 ` Re: Database User Andrew Sullivan <ajs@crankycanuck.ca>
  0 siblings, 1 reply; 2+ messages in thread

From: Carol Walter @ 2007-06-20 15:59 UTC (permalink / raw)
  To: pgsql-admin

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.

Carol



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Database User
  2007-06-20 15:59 Database User Carol Walter <walterc@indiana.edu>
@ 2007-06-20 18:09 ` Andrew Sullivan <ajs@crankycanuck.ca>
  0 siblings, 0 replies; 2+ messages in thread

From: Andrew Sullivan @ 2007-06-20 18:09 UTC (permalink / raw)
  To: pgsql-admin

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@crankycanuck.ca
The plural of anecdote is not data.
		--Roger Brinner



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-06-20 18:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-20 15:59 Database User Carol Walter <walterc@indiana.edu>
2007-06-20 18:09 ` Andrew Sullivan <ajs@crankycanuck.ca>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox