X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 961A69DC93F for ; Sun, 22 Jan 2006 22:36:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25463-04 for ; Sun, 22 Jan 2006 22:36:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by postgresql.org (Postfix) with ESMTP id 974449DC8AD for ; Sun, 22 Jan 2006 22:36:13 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 8F65335CD0; Sun, 22 Jan 2006 18:35:07 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 7FC4135CC1; Sun, 22 Jan 2006 18:35:07 -0800 (PST) Date: Sun, 22 Jan 2006 18:35:06 -0800 (PST) From: Stephan Szabo To: Dan Bikle Cc: pgsql-admin@postgresql.org Subject: Re: [pgsql-admin] Simple question about security in 8.1.1 In-Reply-To: <74252ed10601221802s6c697348w5c405292f17c86ef@mail.gmail.com> Message-ID: <20060122183141.G82325@megazone.bigpanda.com> References: <74252ed10601221802s6c697348w5c405292f17c86ef@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-2022-JP Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.143 required=5 tests=[AWL=0.143] X-Spam-Score: 0.143 X-Spam-Level: X-Archive-Number: 200601/261 X-Sequence-Number: 20349 On Sun, 22 Jan 2006, Dan Bikle wrote: > I'm allowed to connect to the db10 database without authentication!: > > bash-2.05b$ psql db10 scott > Welcome to psql 8.1.1, the PostgreSQL interactive terminal. > > Type: =A1=C0copyright for distribution terms > =A1=C0h for help with SQL commands > =A1=C0? for help with psql commands > =A1=C0g or terminate with semicolon to execute query > =A1=C0q to quit > > db10=3D> create table dropme (n integer); > CREATE TABLE > db10=3D> drop table dropme; > DROP TABLE > db10=3D> > > This seems insecure. > > How do I create a postgreSQL user account such that attempts to connect > to it require authentication? You probably should look at the following: http://www.postgresql.org/docs/8.1/interactive/client-authentication.html