Postgres Pro
Downloads
Home   >   mailing lists

Re: GRANT SELECT - Mailing list pgsql-general

From Jasen Betts
Subject Re: GRANT SELECT
Date
Msg-id k1v3b0$1uv$1@reversiblemaps.ath.cx
Whole thread Raw
In response to GRANT SELECT  (Stephen Crawford <src176@psu.edu>)
List pgsql-general
Tree view 
On 2012-08-27, Stephen Crawford <src176@psu.edu> wrote:
> Is there a simple way to grant SELECT privileges to a user for all the
> tables in a database, without having to do it for each table?

grant the role (membership of) a role that already has the priveleges.


--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)
Next
From: Craig Ringer
Date:
Subject: Re: CASE/WHEN behavior with NULLS