Re: Database Permissions

On Wed, Apr 16, 2003 at 14:23:02 -0400,
Blake Crosby <me(at)blakecrosby(dot)com> wrote:
> 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:

Not in 7.2. In 7.3 you can limit who can create schemas in a database and
who can create objects in a schema. There is also a separate control for
creating temporary tables in a database. This should let you do what you
want.