Prevent users to drop triggers applied on table

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Prevent users to drop triggers applied on table
Date: 2010-04-01 07:13:39
Message-ID: q2sd5b05a951004010013n3f5cae98xec0a238cbe9fd3bb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We have been using a stored procedure which allow users to create table. The
stored procedure creates actual table, logging tables, views, and applies
triggers. I want to prevent table owner from deleting the triggers applied
on table by create table stored procedure. Could anyone please suggest me to
get way out here.

Thanks,
Dipti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sylvain Lara 2010-04-01 07:15:08 Re : Re : Re : Select in temporary table
Previous Message Thomas Kellerer 2010-04-01 07:09:27 Re: "1-Click" installer problems