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
> 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:
In response to
pgsql-admin by date
|Next:||From: Joshua D. Drake||Date: 2006-01-23 04:28:49|
|Subject: Re: [pgsql-admin] Simple question about security in 8.1.1|
|Previous:||From: Dan Bikle||Date: 2006-01-23 02:02:50|
|Subject: [pgsql-admin] Simple question about security in 8.1.1|