| 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: | Whole Thread | Raw Message | 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,
| 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 |