Thread: GRANT access on fti() function
This grants execute privileges to public for the fti() function. Should we go through and give all the contribs grants? Chris Index: fti.sql.in =================================================================== RCS file: /projects/cvsroot/pgsql-server/contrib/fulltextindex/fti.sql.in,v retrieving revision 1.5 diff -c -r1.5 fti.sql.in *** fti.sql.in 2002/09/02 06:27:04 1.5 --- fti.sql.in 2002/09/16 02:14:17 *************** *** 1,3 **** --- 1,6 ---- CREATE OR REPLACE FUNCTION fti() RETURNS trigger AS 'MODULE_PATHNAME', 'fti' LANGUAGE 'C' VOLATILE CALLED ON NULL INPUT; + + GRANT EXECUTE ON FUNCTION fti() TO PUBLIC; +
Your patch has been added to the PostgreSQL unapplied patches list at: http://candle.pha.pa.us/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --------------------------------------------------------------------------- Christopher Kings-Lynne wrote: > This grants execute privileges to public for the fti() function. Should we > go through and give all the contribs grants? > > Chris > > Index: fti.sql.in > =================================================================== > RCS file: /projects/cvsroot/pgsql-server/contrib/fulltextindex/fti.sql.in,v > retrieving revision 1.5 > diff -c -r1.5 fti.sql.in > *** fti.sql.in 2002/09/02 06:27:04 1.5 > --- fti.sql.in 2002/09/16 02:14:17 > *************** > *** 1,3 **** > --- 1,6 ---- > CREATE OR REPLACE FUNCTION fti() RETURNS trigger AS > 'MODULE_PATHNAME', 'fti' > LANGUAGE 'C' VOLATILE CALLED ON NULL INPUT; > + > + GRANT EXECUTE ON FUNCTION fti() TO PUBLIC; > + > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- 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
Patch applied. Thanks. --------------------------------------------------------------------------- Christopher Kings-Lynne wrote: > This grants execute privileges to public for the fti() function. Should we > go through and give all the contribs grants? > > Chris > > Index: fti.sql.in > =================================================================== > RCS file: /projects/cvsroot/pgsql-server/contrib/fulltextindex/fti.sql.in,v > retrieving revision 1.5 > diff -c -r1.5 fti.sql.in > *** fti.sql.in 2002/09/02 06:27:04 1.5 > --- fti.sql.in 2002/09/16 02:14:17 > *************** > *** 1,3 **** > --- 1,6 ---- > CREATE OR REPLACE FUNCTION fti() RETURNS trigger AS > 'MODULE_PATHNAME', 'fti' > LANGUAGE 'C' VOLATILE CALLED ON NULL INPUT; > + > + GRANT EXECUTE ON FUNCTION fti() TO PUBLIC; > + > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- 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