Auto-committed schema changes.

diff --git a/schema/roles.sql b/schema/roles.sql
index c59eeb5c169c0021546dbbf127a8bd8884006a4f..544e2486481eb53aeb22d8e79aa8b22c0085b542 100644 (file)
--- a/schema/roles.sql
+++ b/schema/roles.sql
@@ -1,78 +1,153 @@
 CREATE ROLE aba;
+ALTER ROLE aba WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE adsb;
+ALTER ROLE adsb WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE aloiret;
+ALTER ROLE aloiret WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE alpha;
+ALTER ROLE alpha WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE amd64;
+ALTER ROLE amd64 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE arm;
+ALTER ROLE arm WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE armel;
+ALTER ROLE armel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE aurel32;
+ALTER ROLE aurel32 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_alpha;
+ALTER ROLE buildd_alpha WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_amd64;
+ALTER ROLE buildd_amd64 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_arm;
+ALTER ROLE buildd_arm WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_armel;
+ALTER ROLE buildd_armel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_hppa;
+ALTER ROLE buildd_hppa WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE "buildd_hurd-i386";
+ALTER ROLE "buildd_hurd-i386" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_i386;
+ALTER ROLE buildd_i386 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_ia64;
+ALTER ROLE buildd_ia64 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE "buildd_kfreebsd-amd64";
+ALTER ROLE "buildd_kfreebsd-amd64" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE "buildd_kfreebsd-i386";
+ALTER ROLE "buildd_kfreebsd-i386" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_mips;
+ALTER ROLE buildd_mips WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_mipsel;
+ALTER ROLE buildd_mipsel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_powerpc;
+ALTER ROLE buildd_powerpc WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_s390;
+ALTER ROLE buildd_s390 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE buildd_sparc;
+ALTER ROLE buildd_sparc WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE colint;
+ALTER ROLE colint WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE dannf;
+ALTER ROLE dannf WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE devin;
+ALTER ROLE devin WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE fs;
+ALTER ROLE fs WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE fw;
+ALTER ROLE fw WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE geissert;
+ALTER ROLE geissert WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE glondu;
+ALTER ROLE glondu WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE guest;
+ALTER ROLE guest WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE he;
+ALTER ROLE he WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE hppa;
+ALTER ROLE hppa WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE "hurd-i386";
+ALTER ROLE "hurd-i386" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE i386;
+ALTER ROLE i386 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE ia64;
+ALTER ROLE ia64 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE iuculano;
+ALTER ROLE iuculano WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE jcristau;
+ALTER ROLE jcristau WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE jmm;
+ALTER ROLE jmm WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE joey;
+ALTER ROLE joey WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE jwilk;
+ALTER ROLE jwilk WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE "kfreebsd-amd64";
+ALTER ROLE "kfreebsd-amd64" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE "kfreebsd-i386";
+ALTER ROLE "kfreebsd-i386" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE kibi;
+ALTER ROLE kibi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE kroeckx;
+ALTER ROLE kroeckx WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE lamont;
+ALTER ROLE lamont WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE luk;
+ALTER ROLE luk WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE mbanck;
+ALTER ROLE mbanck WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE mehdi;
+ALTER ROLE mehdi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE mips;
+ALTER ROLE mips WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE mipsel;
+ALTER ROLE mipsel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE nion;
+ALTER ROLE nion WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE noahm;
+ALTER ROLE noahm WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE nomeata;
+ALTER ROLE nomeata WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE p2;
+ALTER ROLE p2 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE pkern;
+ALTER ROLE pkern WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE postgres;
+ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
 CREATE ROLE powerpc;
+ALTER ROLE powerpc WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE riku;
+ALTER ROLE riku WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE s390;
+ALTER ROLE s390 WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE seb;
+ALTER ROLE seb WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE sf;
+ALTER ROLE sf WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE sparc;
+ALTER ROLE sparc WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE sthibault;
+ALTER ROLE sthibault WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE thijs;
+ALTER ROLE thijs WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE vorlon;
+ALTER ROLE vorlon WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE waldi;
+ALTER ROLE waldi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE wb_all;
+ALTER ROLE wb_all WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE wb_security;
+ALTER ROLE wb_security WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE wbadm;
+ALTER ROLE wbadm WITH NOSUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
 CREATE ROLE white;
+ALTER ROLE white WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE wookey;
+ALTER ROLE wookey WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE wouter;
+ALTER ROLE wouter WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE zobel;
+ALTER ROLE zobel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE zumbi;
+ALTER ROLE zumbi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 GRANT alpha TO buildd_alpha GRANTED BY wbadm;
 GRANT alpha TO kibi GRANTED BY wbadm;
 GRANT alpha TO wb_all GRANTED BY wbadm;