REVOKE DROP rights

From: Miles Elam <miles(dot)elam(at)productops(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: REVOKE DROP rights
Date: 2019-09-11 16:42:15
Message-ID: CAALojA-ZKo-a3kYkYbF-D_+rHGVh08ocpZWgLTrT6iixOc2diQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way to prevent a user from dropping a table when that user has
create rights? I'd like to allow that user to be able to create and delete
their own tables but not specific shared tables.

Is the only way to put the shared tables into a different schema?

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albretch Mueller 2019-09-11 16:46:57 Re: kind of a bag of attributes in a DB . . .
Previous Message Francisco Olarte 2019-09-11 16:34:04 Re: How to reformat output of "age()" function