Postgres Pro
Downloads
Home   >   mailing lists

Deny creation of tables for a user - Mailing list pgsql-general

From Pascal Cohen
Subject Deny creation of tables for a user
Date
Msg-id 480F1394.5030302@wimba.com
Whole thread Raw
Responses Re: Deny creation of tables for a user  (Terry Lee Tucker <terry@chosen-ones.org>)
Re: Deny creation of tables for a user  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view 
Hello
I am playing with security in Postgres
And I would like to have a database that can be managed by a given user
that could do almost anything but I would also have a user that can just
handle what is created.
I mean she could insert, update delete rows but not create tables.

I did not find a way to revoke such thing. Is it possible ?

Thanks!

pgsql-general by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: Need to update all my 60 million rows at once without transactional integrity
Next
From: Tomasz Ostrowski
Date:
Subject: Re: Rapidly decaying performance repopulating a large table