Re: RESTRICT TABLE OWNER NOT TO DELETE IT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Peter Wainaina <petwah17@xxxxxxxxx>
Subject: Re: RESTRICT TABLE OWNER NOT TO DELETE IT
From: Greg Spiegelberg <gspiegelberg@xxxxxxxxx>
Date: Mon, 8 Mar 2021 06:47:31 -0700
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAEEbwbfqg-xForZePcXDeuvP0mUWMRO6ys0ot_2rnhor6Ogppg@mail.gmail.com>
References: <CAEEbwbfqg-xForZePcXDeuvP0mUWMRO6ys0ot_2rnhor6Ogppg@mail.gmail.com>

On Mon, Mar 8, 2021 at 4:24 AM Peter Wainaina <petwah17@xxxxxxxxx> 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

References:
- RESTRICT TABLE OWNER NOT TO DELETE IT
  - From: Peter Wainaina

Prev by Date: RESTRICT TABLE OWNER NOT TO DELETE IT
Next by Date: Re: could not load library "$libdir/plpython2" while upgrading from postgresql-10 to 12
Previous by thread: RESTRICT TABLE OWNER NOT TO DELETE IT
Next by thread: Re: RESTRICT TABLE OWNER NOT TO DELETE IT
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux