Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] Question on TRUNCATE privleges

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>,pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [NOVICE] Question on TRUNCATE privleges
Date: 2005-02-24 22:28:08
Message-ID: 20050224222631.M29042@narrowpathinc.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-novice
On Thu, 24 Feb 2005 17:15:42 -0500, Tom Lane wrote
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Uh, that seems like it adds extra complexity just for this single case.
> 
> Yeah.  I've dropped the idea personally -- the suggestion that the table
> owner can provide a SECURITY DEFINER procedure to do the TRUNCATE if 
> he wants to allow others to do it seems to me to cover the problem.

Could someone point me in the direction of documentation on this SECURITY
DEFINER feature?

Kind Regards,
Keith

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2005-02-24 22:47:44
Subject: Re: [NOVICE] Question on TRUNCATE privleges
Previous:From: Bruce MomjianDate: 2005-02-24 22:21:29
Subject: Re: [NOVICE] Question on TRUNCATE privleges

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-02-24 22:28:44
Subject: Re: [PATCHES] [pgsql-hackers-win32] Repleacement for src/port/snprintf.c
Previous:From: Bruce MomjianDate: 2005-02-24 22:27:25
Subject: Re: [PATCHES] [pgsql-hackers-win32] Repleacement for src/port/snprintf.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group