--=-13v32rS7j/lFCjcarBay
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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

--=-13v32rS7j/lFCjcarBay
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada
digitalmente

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQBAoit92WzuCgGWJ3kRAmtaAJwIkJVEqw2bYTEle6hcDBFWM8aTXwCe NVdf
0vHeZHfao4JgeqGnRUhP8Eg=
=Yv/t
-----END PGP SIGNATURE-----

--=-13v32rS7j/lFCjcarBay--

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo [at] postgresql.org so that your
message can get through to the mailing list cleanly