Thread: about psql user

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

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@commandprompt.com | Telephone: (503) 667.4564