| From: | Robby Russell <rrussell(at)commandprompt(dot)com> |
|---|---|
| To: | Joe Nilson Zegarra Galvez <nzegarra(at)kolareal(dot)net> |
| Cc: | Lista PG-PHP <pgsql-php(at)postgresql(dot)org> |
| Subject: | Re: about psql user |
| Date: | 2004-05-12 14:28:44 |
| Message-ID: | 40A2349C.9020503@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
Joe Nilson Zegarra Galvez typed this on 05/12/2004 06:49 AM:
> sorry, if its not a quiestion for the list, but i want know if is
> posible config one user with readonly access to a DB in postgresql, i'm
> seeking it in the manual and only found a entry in a Postgre95 ver 0.3
> manual :-( nothing in the 7.4.2 documentation, i'm devel an app with php
> and pgsql and some users only can make selects without inserts, deletes
> or updates and this is the reason for the readonly user.
>
> Thanks for your help.
>
> Regards
>
> Joe Nilson
Try this:
http://developer.postgresql.org/docs/postgres/sql-grant.html
GRANT SELECT...
-RObby
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
rrussell(at)commandprompt(dot)com | Telephone: (503) 667.4564
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2004-05-12 21:51:24 | error codes |
| Previous Message | Joe Nilson Zegarra Galvez | 2004-05-12 13:49:50 | about psql user |