Re: *** Newbie Question About PostgreSQL ***
You should look through the PostgreSQL documentation. But basically, you
manage users using SQL:
CREATE USER foo WITH PASSWORD bar;
GRANT READ ON table TO foo;
REVOKE DELETE ON table FROM foo;
----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin@unc.edu - http://www.unc.edu/~aperrin
Asst Professor of Sociology, U of North Carolina, Chapel Hill
269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA
On Tue, 29 May 2001, Arcadio A. Sincero Jr. wrote:
> Hello list,
>
> I'd like to set up Postgresql so that users can have "read-only" access to a
> database. Right now, I only know how to set it so a user can have all or
> nothing access by adding something like the following in the pg_hba.conf
> file:
>
> local mydb crypt users.mydb
>
> And put the names of all the users I want to allow access to the "mydb"
> database into the users.mydb file. But like I said, this only allows all or
> nothing access to the database. A user can still do a CREATE TABLE and add
> additional tables to the database. Is there anyway to have it so a user can
> only do SELECTs? Thanks.
>
> - Arcadio
>
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
>
Reply to: