Обсуждение: Grants on creating tables..

I've read that in postgres v 7.3 and above is possible to set
permissions for creating tables in given database...

I've tried in many various ways, byt always given user can create
tables in database.

Have you got any idea ?
Maybe some example ??

Thanks in advance
Andrzej Kwiatkowski

On Mon, 13 Jan 2003, Andrzej Kwiatkowski wrote:

> I've read that in postgres v 7.3 and above is possible to set
> permissions for creating tables in given database...
>
> I've tried in many various ways, byt always given user can create
> tables in database.

If you remove the create permission from all of the schemas for the user
they shouldn't be able to create non-temporary tables. On my empty 7.4
devel database, after doing

REVOKE CREATE on SCHEMA public FROM public;

a random non-superuser account on the database no longer can create tables
(apart from temporary ones).

On Mon, Jan 13, 2003 at 14:59:58 -0800,
  Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
>
> On Mon, 13 Jan 2003, Andrzej Kwiatkowski wrote:
>
> > I've read that in postgres v 7.3 and above is possible to set
> > permissions for creating tables in given database...
> >
> > I've tried in many various ways, byt always given user can create
> > tables in database.
>
> If you remove the create permission from all of the schemas for the user
> they shouldn't be able to create non-temporary tables. On my empty 7.4
> devel database, after doing
>
> REVOKE CREATE on SCHEMA public FROM public;
>
> a random non-superuser account on the database no longer can create tables
> (apart from temporary ones).

You also probably want to revoke create on the database so that the person
cannot create schemas in which they could create tables.