X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=add_constraints.sql;h=dd366c3a3bf515e24fccfe77da1fdb1e83f22d6d;hb=4b41dc06229eed89f52f397fc7df5d665fa092cf;hp=a23951f720289de0bb948626fb940edfb5dd2ba2;hpb=9ebfa30b056df56376cb0302a28a190e0aaed765;p=dak.git

diff --git a/add_constraints.sql b/add_constraints.sql
index a23951f7..dd366c3a 100644
--- a/add_constraints.sql
+++ b/add_constraints.sql
@@ -74,33 +74,20 @@ GRANT ALL ON
   bin_associations, bin_associations_id_seq, binaries,
   binaries_id_seq, component, component_id_seq, dsc_files,
   dsc_files_id_seq, files, files_id_seq, location, location_id_seq,
-  maintainer, maintainer_id_seq, source, source_id_seq,
-  src_associations, src_associations_id_seq, suite,
-  suite_architectures, suite_id_seq
+  maintainer, maintainer_id_seq, override, override_type,
+  override_type_id_seq, priority, priority_id_seq, section,
+  section_id_seq, source, source_id_seq, src_associations,
+  src_associations_id_seq, suite, suite_architectures, suite_id_seq
      TO GROUP ftpmaster;
 
--- Give write privileges to the associations tables for AJ for the purposes of `testing'
-GRANT ALL ON 
-  binaries, binaries_id_seq, 
-  bin_associations, bin_associations_id_seq,
-  source, source_id_seq, 
-  src_associations, src_associations_id_seq,
-  suite, suite_id_seq 
-     TO ajt;
-
--- RO access to AJ for all other tables
-GRANT SELECT ON 
-  architecture, archive, binaries, component,
-  dsc_files, files, location, maintainer, source, suite, suite_architectures
-     TO ajt;
-
 -- Read only access to user 'nobody'
 GRANT SELECT ON 
   architecture, architecture_id_seq, archive, archive_id_seq,
   bin_associations, bin_associations_id_seq, binaries,
   binaries_id_seq, component, component_id_seq, dsc_files,
   dsc_files_id_seq, files, files_id_seq, location, location_id_seq,
-  maintainer, maintainer_id_seq, source, source_id_seq,
-  src_associations, src_associations_id_seq, suite,
-  suite_architectures, suite_id_seq
+  maintainer, maintainer_id_seq, override, override_type,
+  override_type_id_seq, priority, priority_id_seq, section,
+  section_id_seq, source, source_id_seq, src_associations,
+  src_associations_id_seq, suite, suite_architectures, suite_id_seq
      TO PUBLIC;