How to prevent users from creating tables - Mailing list pgsql-admin

From raf
Subject How to prevent users from creating tables
Date
Msg-id 20090204005222.GA19588@raf.org
Whole thread Raw
Responses Re: How to prevent users from creating tables  ("Milen A. Radev" <milen@radev.net>)
List pgsql-admin
hi,

in my database, normal users can't select, insert, update or
delete anything directly. they can only call functions which
are all security defining functions which give access to the
data. that's the way i like it.

however, i discovered that normal users can create new
tables in the database. is there any way to prevent this?
i couldn't find any grant/revoke syntax in the doco that
looked relevant.

cheers,
raf


pgsql-admin by date:

Previous
From: Lee Azzarello
Date:
Subject: Re: Warm standby recovery failure
Next
From: "Daniel J. Summers"
Date:
Subject: Re: Permissions to a schema