Thread: Database Permissions

Database Permissions

From
Blake Crosby
Date:
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


Re: Database Permissions

From
Bruno Wolff III
Date:
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.