Re: Database Permissions - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Database Permissions
Date
Msg-id 20030416183459.GA19826@wolff.to
Whole thread Raw
In response to Database Permissions  (Blake Crosby <me@blakecrosby.com>)
List pgsql-admin
On Wed, Apr 16, 2003 at 14:23:02 -0400,
  Blake Crosby <me@blakecrosby.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.


pgsql-admin by date:

Previous
From: Blake Crosby
Date:
Subject: Database Permissions
Next
From: "Greg Kelley"
Date:
Subject: Require Assistance Solving Problem - erroneous pg_hba.conf