Re: RESTRICT TABLE OWNER NOT TO DELETE IT

From: Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>
To: Peter Wainaina <petwah17(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: RESTRICT TABLE OWNER NOT TO DELETE IT
Date: 2021-03-08 13:47:31
Message-ID: CAEtnbpXsCKBmdgpp3N60_nvhdGXojQNmXV5iUO5V6fM_hA+7Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Mar 8, 2021 at 4:24 AM Peter Wainaina <petwah17(at)gmail(dot)com> wrote:

> Hi
> i need help on how to restrict the table owner no to drop/truncate the
> table
>

Believe you are looking for Event Triggers.
https://www.postgresql.org/docs/12/event-trigger-example.html

-Greg

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message RAJAMOHAN 2021-03-08 14:29:04 Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
Previous Message Peter Wainaina 2021-03-08 11:23:43 RESTRICT TABLE OWNER NOT TO DELETE IT