how to grant SELECT access to a database?

From: Charlie Reddington <charlie(dot)reddington(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to grant SELECT access to a database?
Date: 2008-12-08 17:33:14
Message-ID: FDE7A407-3235-4817-8179-EF53E260E791@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm really new to PG, so if this is overly newbish, please send me to
the appropriate tutorial.

I have come from a mysql background, so giving access to for a user or
app to just read the appropriate mail list was easy with something
like 'grant select on DB to USER;'.

I have found I can grant ALL PRIVILEGES, but not just select to a
particular DB.

I can use some hand holding here to grant read only to a db the right
way, as I rather not just do a grant all privs. FYI, granting to a
particular set of tables will not work, as we have a 'dynamic' db.

Thanks for the help,

Browse pgsql-admin by date

  From Date Subject
Next Message Milen A. Radev 2008-12-08 21:06:52 Re: How can we see details of function in psql prompt
Previous Message Scott Marlowe 2008-12-08 17:28:16 Re: Vacuum Problems