Postgres Pro
Downloads
Home   >   mailing lists

Re: Allow user to create tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Allow user to create tables
Date
Msg-id 23049.1020778864@sss.pgh.pa.us
Whole thread Raw
In response to Allow user to create tables  ("Tille, Andreas" <TilleA@rki.de>)
Responses PgAdmin2 trouble (Was: Allow user to create tables)
Re: Allow user to create tables
List pgsql-general
Tree view 
"Tille, Andreas" <TilleA@rki.de> writes:
> I just created a database and granted all rights to the tables I created to
> an additional user.  I observed that this user does not have the right to
> create additional tables.

I think you have that backwards ;-).  In PG you *cannot prevent* a user
from being able to create tables.

7.3 will have permissions that control this, but no extant release does.

            regards, tom lane

pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Contrib reindex script:
Next
From: Francisco Reyes
Date:
Subject: Re: Index usage vs large repetitions of key