Re: [pgsql-admin] Simple question about security in 8.1.1

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