Blocking object creation for some users

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: Blocking object creation for some users
Date: 2002-04-01 21:33:07
Message-ID: 20020401213307.GA25015@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to keep users from creating new objects in a database
while letting them access existing objects in the same database?

It doesn't look like there is a clean (e.g. with GRANT) way to do this. I
tried looking to see if there was a sneaky way to block update access to some
of the system tables, but that doesn't seem to be doable either.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-04-01 21:51:52 Re: parsing relname in pg_class
Previous Message Johnson, Shaunn 2002-04-01 21:29:34 parsing relname in pg_class