pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedabout psql user
2+ messages / 2 participants
[nested] [flat]
* about psql user
@ 2004-05-12 13:49 Joe Nilson Zegarra Galvez <nzegarra@kolareal.net>
0 siblings, 1 reply; 2+ messages in thread
From: Joe Nilson Zegarra Galvez @ 2004-05-12 13:49 UTC (permalink / raw)
To: pgsql-php
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
Attachments:
signature.asc (application/pgp-signature, 188B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: about psql user
@ 2004-05-12 14:28 Robby Russell <rrussell@commandprompt.com>
parent: Joe Nilson Zegarra Galvez <nzegarra@kolareal.net>
0 siblings, 0 replies; 2+ messages in thread
From: Robby Russell @ 2004-05-12 14:28 UTC (permalink / raw)
To: Joe Nilson Zegarra Galvez <nzegarra@kolareal.net>; +Cc: 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@commandprompt.com | Telephone: (503) 667.4564
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-05-12 14:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-12 13:49 about psql user Joe Nilson Zegarra Galvez <nzegarra@kolareal.net>
2004-05-12 14:28 ` Robby Russell <rrussell@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox