X-Git-Url: https://git.donarmstrong.com/?p=wannabuild.git;a=blobdiff_plain;f=schema%2Froles.sql;h=455bdac401bdec2a8bed0ad6f97608646b5a2892;hp=da7525873b7dbb39a4b2b1c82f0e0f29f493024f;hb=4c573dc949bdc79de818308ba277b10d0a20f16d;hpb=1ce45d5d1ec7ac0b437da500893cd4c08c04dd0c

diff --git a/schema/roles.sql b/schema/roles.sql
index da75258..455bdac 100644
--- a/schema/roles.sql
+++ b/schema/roles.sql
@@ -1,94 +1,250 @@
-create role alpha;
-create role amd64;
-create role arm;
-create role armel;
-create role hppa;
-create role i386;
-create role ia64;
-create role "kfreebsd-amd64";
-create role "kfreebsd-i386";
-create role mips;
-create role mipsel;
-create role powerpc;
-create role s390;
-create role sparc;
-create role "hurd-i386";
-
-create user buildd_alpha;
-create user buildd_amd64;
-create user buildd_arm;
-create user buildd_armel;
-create user buildd_hppa;
-create user buildd_i386;
-create user buildd_ia64;
-create user "buildd_kfreebsd-amd64";
-create user "buildd_kfreebsd-i386";
-create user buildd_mips;
-create user buildd_mipsel;
-create user buildd_powerpc;
-create user buildd_s390;
-create user buildd_sparc;
-create user "buildd_hurd-i386";
-
-grant alpha to buildd_alpha;
-grant amd64 to buildd_amd64;
-grant arm to buildd_arm;
-grant armel to buildd_armel;
-grant hppa to buildd_hppa;
-grant i386 to buildd_i386;
-grant ia64 to buildd_ia64;
-grant "kfreebsd-amd64" to "buildd_kfreebsd-amd64";
-grant "kfreebsd-i386" to "buildd_kfreebsd-i386";
-grant mips to buildd_mips;
-grant mipsel to buildd_mipsel;
-grant powerpc to buildd_powerpc;
-grant s390 to buildd_s390;
-grant sparc to buildd_sparc;
-grant "hurd-i386" to "buildd_hurd-i386";
-
-create role wb_all in role alpha, amd64, arm, armel, hppa, i386, ia64, "kfreebsd-amd64", "kfreebsd-i386", mips, mipsel, powerpc, s390, sparc;
-grant "hurd-i386" to wb_all;
-
-grant wb_all to wbadm;
-
-create user aba in role wbadm;
-create user adeodato in role wbadm;
-create user aloiret in role alpha;
-create user aurel32 in role arm, armel, "kfreebsd-amd64", "kfreebsd-i386";
-create user colint in role arm, armel;
-create user fs in role amd64;
-create user he in role sparc, wbadm;
-create user jurij in role wb_all;
-create user kibi in role "kfreebsd-amd64", "kfreebsd-i386";
-create user kroeckx in role amd64, i386, wb_all, wbadm;
-create user lamont in role hppa, ia64;
-create user luk in role i386, wbadm;
-create user p2 in role mips;
-create user pkern in role i386, powerpc, wbadm;
-create user riku in role arm, armel;
-create user vorlon in role alpha, wb_all;
-create user waldi in role s390;
-create user wookey in role arm, armel;
-create user wouter in role powerpc;
-create user zobel in role mipsel, sparc, wb_all;
-create user sthibault in role "hurd-i386";
-create user mbanck in role "hurd-i386";
-
-create role wb_security;
-
-create user sf in role wb_security;
-create user devin in role wb_security;
-create user fw in role wb_security;
-create user geissert in role wb_security;
-create user iuculano in role wb_security;
-create user jmm in role wb_security;
-create user joey in role wb_security;
-create user nion in role wb_security;
-create user noahm in role wb_security;
-create user seb in role wb_security;
-create user thijs in role wb_security;
-create user white in role wb_security;
-grant wb_security to dannf;
-
-create user nomeata in role wb_all;
-
+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 christoph;
+ALTER ROLE christoph 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 kitterman;
+ALTER ROLE kitterman 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;
+GRANT amd64 TO buildd_amd64 GRANTED BY wbadm;
+GRANT amd64 TO fs GRANTED BY wbadm;
+GRANT amd64 TO i386 GRANTED BY wbadm;
+GRANT amd64 TO kroeckx GRANTED BY wbadm;
+GRANT amd64 TO wb_all GRANTED BY wbadm;
+GRANT arm TO aurel32 GRANTED BY wbadm;
+GRANT arm TO buildd_arm GRANTED BY wbadm;
+GRANT arm TO colint GRANTED BY wbadm;
+GRANT arm TO riku GRANTED BY wbadm;
+GRANT arm TO wb_all GRANTED BY wbadm;
+GRANT arm TO wookey GRANTED BY wbadm;
+GRANT armel TO aurel32 GRANTED BY wbadm;
+GRANT armel TO buildd_armel GRANTED BY wbadm;
+GRANT armel TO colint GRANTED BY wbadm;
+GRANT armel TO riku GRANTED BY wbadm;
+GRANT armel TO wb_all GRANTED BY wbadm;
+GRANT armel TO wookey GRANTED BY wbadm;
+GRANT armel TO zumbi GRANTED BY wbadm;
+GRANT hppa TO buildd_hppa GRANTED BY wbadm;
+GRANT hppa TO dannf GRANTED BY wbadm;
+GRANT hppa TO lamont GRANTED BY wbadm;
+GRANT hppa TO wb_all GRANTED BY wbadm;
+GRANT "hurd-i386" TO "buildd_hurd-i386" GRANTED BY wbadm;
+GRANT "hurd-i386" TO mbanck GRANTED BY wbadm;
+GRANT "hurd-i386" TO sthibault GRANTED BY wbadm;
+GRANT "hurd-i386" TO wb_all GRANTED BY wbadm;
+GRANT i386 TO buildd_i386 GRANTED BY wbadm;
+GRANT i386 TO kroeckx GRANTED BY wbadm;
+GRANT i386 TO pkern GRANTED BY wbadm;
+GRANT i386 TO wb_all GRANTED BY wbadm;
+GRANT ia64 TO buildd_ia64 GRANTED BY wbadm;
+GRANT ia64 TO lamont GRANTED BY wbadm;
+GRANT ia64 TO wb_all GRANTED BY wbadm;
+GRANT "kfreebsd-amd64" TO aurel32 GRANTED BY wbadm;
+GRANT "kfreebsd-amd64" TO "buildd_kfreebsd-amd64" GRANTED BY wbadm;
+GRANT "kfreebsd-amd64" TO christoph GRANTED BY wbadm;
+GRANT "kfreebsd-amd64" TO kibi GRANTED BY wbadm;
+GRANT "kfreebsd-amd64" TO wb_all GRANTED BY wbadm;
+GRANT "kfreebsd-i386" TO aurel32 GRANTED BY wbadm;
+GRANT "kfreebsd-i386" TO "buildd_kfreebsd-i386" GRANTED BY wbadm;
+GRANT "kfreebsd-i386" TO christoph GRANTED BY wbadm;
+GRANT "kfreebsd-i386" TO kibi GRANTED BY wbadm;
+GRANT "kfreebsd-i386" TO wb_all GRANTED BY wbadm;
+GRANT mips TO aba GRANTED BY wbadm;
+GRANT mips TO buildd_mips GRANTED BY wbadm;
+GRANT mips TO p2 GRANTED BY wbadm;
+GRANT mips TO wb_all GRANTED BY wbadm;
+GRANT mipsel TO aba GRANTED BY wbadm;
+GRANT mipsel TO buildd_mipsel GRANTED BY wbadm;
+GRANT mipsel TO wb_all GRANTED BY wbadm;
+GRANT powerpc TO buildd_powerpc GRANTED BY wbadm;
+GRANT powerpc TO pkern GRANTED BY wbadm;
+GRANT powerpc TO wb_all GRANTED BY wbadm;
+GRANT powerpc TO wouter GRANTED BY wbadm;
+GRANT s390 TO buildd_s390 GRANTED BY wbadm;
+GRANT s390 TO pkern GRANTED BY wbadm;
+GRANT s390 TO waldi GRANTED BY wbadm;
+GRANT s390 TO wb_all GRANTED BY wbadm;
+GRANT sparc TO buildd_sparc GRANTED BY wbadm;
+GRANT sparc TO he GRANTED BY wbadm;
+GRANT sparc TO kibi GRANTED BY wbadm;
+GRANT sparc TO wb_all GRANTED BY wbadm;
+GRANT sparc TO zobel GRANTED BY wbadm;
+GRANT wb_all TO adsb GRANTED BY wbadm;
+GRANT wb_all TO aurel32 GRANTED BY wbadm;
+GRANT wb_all TO glondu GRANTED BY wbadm;
+GRANT wb_all TO jcristau GRANTED BY wbadm;
+GRANT wb_all TO jwilk GRANTED BY wbadm;
+GRANT wb_all TO kibi GRANTED BY wbadm;
+GRANT wb_all TO kitterman GRANTED BY wbadm;
+GRANT wb_all TO kroeckx GRANTED BY wbadm;
+GRANT wb_all TO mehdi GRANTED BY wbadm;
+GRANT wb_all TO nomeata GRANTED BY wbadm;
+GRANT wb_all TO vorlon GRANTED BY wbadm;
+GRANT wb_all TO wbadm GRANTED BY wbadm;
+GRANT wb_all TO zobel GRANTED BY wbadm;
+GRANT wb_security TO dannf GRANTED BY wbadm;
+GRANT wb_security TO devin GRANTED BY wbadm;
+GRANT wb_security TO fw GRANTED BY wbadm;
+GRANT wb_security TO geissert GRANTED BY wbadm;
+GRANT wb_security TO iuculano GRANTED BY wbadm;
+GRANT wb_security TO jmm GRANTED BY wbadm;
+GRANT wb_security TO joey GRANTED BY wbadm;
+GRANT wb_security TO nion GRANTED BY wbadm;
+GRANT wb_security TO noahm GRANTED BY wbadm;
+GRANT wb_security TO seb GRANTED BY wbadm;
+GRANT wb_security TO sf GRANTED BY wbadm;
+GRANT wb_security TO thijs GRANTED BY wbadm;
+GRANT wb_security TO white GRANTED BY wbadm;
+GRANT wbadm TO aba GRANTED BY wbadm;
+GRANT wbadm TO he GRANTED BY wbadm;
+GRANT wbadm TO kroeckx GRANTED BY wbadm;
+GRANT wbadm TO pkern GRANTED BY wbadm;