Re: GRANT SELECT

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT SELECT
Date: 2012-09-02 07:54:08
Message-ID: k1v3b0$1uv$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-08-27, Stephen Crawford <src176(at)psu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-09-02 11:41:37 Re: CASE/WHEN behavior with NULLS
Previous Message Jasen Betts 2012-09-02 07:25:16 Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)