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 - [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > >
