how to grant SELECT access to a database? - Mailing list pgsql-admin

From Charlie Reddington
Subject how to grant SELECT access to a database?
Date
Msg-id FDE7A407-3235-4817-8179-EF53E260E791@gmail.com
Whole thread Raw
List 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,

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Vacuum Problems
Next
From: AmitKumar Jain
Date:
Subject: How can we see details of function in psql prompt