about psql user

Поиск
Список
Период
Сортировка
Искать

about psql user

От:
Joe Nilson Zegarra Galvez <nzegarra@kolareal.net>
Дата:
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

Re: about psql user

От:
Robby Russell <rrussell@commandprompt.com>
Дата:
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
FAQ