Tom, when you loosened the restriction on reindexing toast tables, did
you continue to restrict indexing of system tables to the superuser?  Is
that required?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Mon, 2 Sep 2002 16:07:08 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
reindex of toast tables
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom, when you loosened the restriction on reindexing toast tables, did
> you continue to restrict indexing of system tables to the superuser?  Is
> that required?

Hm.  Now that I look at it, the forms REINDEX TABLE and REINDEX INDEX
don't seem to have any permissions checks at all :-(.  One would think
that they need to require ownership rights on the target table.

			regards, tom lane

Mon, 02 Sep 2002 16:29:45 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: reindex of toast tables 
Tom Lane dijo: 

> Hm.  Now that I look at it, the forms REINDEX TABLE and REINDEX INDEX
> don't seem to have any permissions checks at all :-(.  One would think
> that they need to require ownership rights on the target table.

They are done in tcop/utility.c AFAICS.

-- 
Alvaro Herrera (<alvherre[a]atentus.com>)
"Cuando maï¿½ana llegue pelearemos segun lo que maï¿½ana exija" (Mowgli)


Mon, 2 Sep 2002 16:37:55 -0400 (CLT)
Alvaro Herrera <alvherre@atentus.com>
Re: reindex of toast tables 
Alvaro Herrera <alvherre@atentus.com> writes:
> Tom Lane dijo: 
>> Hm.  Now that I look at it, the forms REINDEX TABLE and REINDEX INDEX
>> don't seem to have any permissions checks at all :-(.  One would think
>> that they need to require ownership rights on the target table.

> They are done in tcop/utility.c AFAICS.

Oh, right.  I was just looking at the catalog/index routines.  Nevermind...

			regards, tom lane

Mon, 02 Sep 2002 19:50:56 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: reindex of toast tables 