How to grant a user read-only access to a database?

From: Antonio Goméz Soto <antonio(dot)gomez(dot)soto(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to grant a user read-only access to a database?
Date: 2010-03-02 11:12:23
Message-ID: 4B8CF297.4040404@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I tried this:

names=# grant select on database names to spice;
ERROR: invalid privilege type SELECT for database

The documentation seems to imply I need to grant SELECT
to each table separately. That's a lot of work, and what if
new tables are created?

Thanks,
Antonio

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-03-02 11:27:59 Re: How to grant a user read-only access to a database?
Previous Message Asher Hoskins 2010-03-02 10:47:03 to_timestamp() and quarters