londiste: make all table-access functions security definer

4 files changed, 4 insertions, 4 deletions

diff --git a/sql/londiste/functions/londiste.link.sql b/sql/londiste/functions/londiste.link.sql
index befedf04..c9a7e09f 100644
--- a/sql/londiste/functions/londiste.link.sql
+++ b/sql/londiste/functions/londiste.link.sql
@@ -41,7 +41,7 @@ begin
     end loop;
     return list1 = list2;
 end;
-$$ language plpgsql;
+$$ language plpgsql security definer;
 
 create or replace function londiste.link(i_source_name text, i_dest_name text, prov_tick_id bigint, prov_tbl_list text, prov_seq_list text)
 returns text as $$
diff --git a/sql/londiste/functions/londiste.provider_add_table.sql b/sql/londiste/functions/londiste.provider_add_table.sql
index 354b5572..1e14c39b 100644
--- a/sql/londiste/functions/londiste.provider_add_table.sql
+++ b/sql/londiste/functions/londiste.provider_add_table.sql
@@ -44,5 +44,5 @@ begin
     return londiste.provider_add_table(i_queue_name, i_table_name,
         londiste.find_column_types(i_table_name));
 end;
-$$ language plpgsql;
+$$ language plpgsql security definer;
 
diff --git a/sql/londiste/functions/londiste.provider_notify_change.sql b/sql/londiste/functions/londiste.provider_notify_change.sql
index 65505fb0..2b6576eb 100644
--- a/sql/londiste/functions/londiste.provider_notify_change.sql
+++ b/sql/londiste/functions/londiste.provider_notify_change.sql
@@ -22,5 +22,5 @@ begin
 
     return 1;
 end;
-$$ language plpgsql;
+$$ language plpgsql security definer;
 
diff --git a/sql/londiste/functions/londiste.subscriber_remove_table.sql b/sql/londiste/functions/londiste.subscriber_remove_table.sql
index 49af4053..23f21246 100644
--- a/sql/londiste/functions/londiste.subscriber_remove_table.sql
+++ b/sql/londiste/functions/londiste.subscriber_remove_table.sql
@@ -23,5 +23,5 @@ begin
 
     return 0;
 end;
-$$ language plpgsql;
+$$ language plpgsql security definer;