Database Permissions - Mailing list pgsql-admin

From Blake Crosby
Subject Database Permissions
Date
Msg-id 75BD0F68-7038-11D7-854A-000A2791C8A8@blakecrosby.com
Whole thread Raw
Responses Re: Database Permissions
List pgsql-admin
Hello,

Currently users who dont own a specific database can still create
tables in that database:

bcrosby=> \c fox
You are now connected to database fox.
fox=> create table testing (id serial);
NOTICE:  CREATE TABLE will create implicit sequence 'testing_id_seq'
for SERIAL column 'testing.id'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index
'testing_id_key' for table 'testing'
CREATE

Is there any way around this? I am  using postgresql version 7.2. My
pg_hba.conf contains:

local        all                                           password
host         all         127.0.0.1     255.255.255.255     password

Blake


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Clarification on RH Upgrade, pgsql not working - erroneous pg_hba.conf
Next
From: Bruno Wolff III
Date:
Subject: Re: Database Permissions