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). ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
