From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Blake Crosby <me(at)blakecrosby(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database Permissions |
Date: | 2003-04-16 18:34:59 |
Message-ID: | 20030416183459.GA19826@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Dalton | 2003-04-16 22:22:43 | Re: new user |
Previous Message | Blake Crosby | 2003-04-16 18:23:02 | Database Permissions |