How to prevent users from creating tables

From: raf <raf(at)raf(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to prevent users from creating tables
Date: 2009-02-04 00:52:22
Message-ID: 20090204005222.GA19588@raf.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel J. Summers 2009-02-04 01:28:42 Re: Permissions to a schema
Previous Message Lee Azzarello 2009-02-03 21:40:55 Re: Warm standby recovery failure