Re: select any table - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: select any table
Date
Msg-id 47E95110.1030400@iol.ie
Whole thread Raw
In response to select any table  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-general
On 25/03/2008 14:54, Roberts, Jon wrote:
> I have some users that need "select any table" but they should not be
> superusers.  How can this be done?
>
> I need a "grant select on <dbname> to <rolename>".

PgAdmin (www.pgadmin.org) has a handy "Grant Wizard" which will do this
for you in one go.

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Converting mysql "on update" to postgres "rule"
Next
From: Charles Simard
Date:
Subject: Re: Converting mysql "on update" to postgres "rule"