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: ＼copyright for distribution terms > ＼h for help with SQL commands > ＼? for help with psql commands > ＼g or terminate with semicolon to execute query > ＼q to quit > > db10=> create table dropme (n integer); > CREATE TABLE > db10=> drop table dropme; > DROP TABLE > db10=> > > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
