X-Git-Url: https://git.donarmstrong.com/?p=wannabuild.git;a=blobdiff_plain;f=schema%2Froles.sql;h=88b3f0c7225f2ea276edd86a3399fb93e88aa902;hp=3065781a6806f9344ddf7b3efea16af8956c6d30;hb=b29132fc05908eb1b831b1ff7f6761278984bcdc;hpb=3a0c3c3d9556f95463f7985838e0fab5884eab6a diff --git a/schema/roles.sql b/schema/roles.sql index 3065781..88b3f0c 100644 --- a/schema/roles.sql +++ b/schema/roles.sql @@ -1,76 +1,157 @@ 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; @@ -91,6 +172,7 @@ 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; @@ -108,10 +190,12 @@ 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; @@ -136,10 +220,13 @@ 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 luk 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;