X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Froles.sql;fp=schema%2Froles.sql;h=77ca04ca5039bd3807bdb36c2015598498a19220;hb=d3a10f8a3ee8780bcc4d163eb9cbea99023529df;hp=ffe5a63baf456273316624d0eb42d4971026c473;hpb=4f9e76c2aece92a0bc59579c8d1f55d9a54a174d;p=wannabuild.git

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