X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Froles.sql;h=fb24983fa2eab8f1d4fb2472e56105e65472edbc;hb=d06ca9bc270320f65501f46d3789c9233b84ec12;hp=77ca04ca5039bd3807bdb36c2015598498a19220;hpb=b8ad8372c7434d56931df89bc1df3589aa0ffac5;p=wannabuild.git diff --git a/schema/roles.sql b/schema/roles.sql index 77ca04c..fb24983 100644 --- a/schema/roles.sql +++ b/schema/roles.sql @@ -1,153 +1,215 @@ 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; -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; +ALTER ROLE zobel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN; +CREATE ROLE zumbi; +ALTER ROLE zumbi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN; 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 buildd_alpha GRANTED BY wbadm; +GRANT wb_all TO buildd_amd64 GRANTED BY wbadm; +GRANT wb_all TO buildd_arm GRANTED BY wbadm; +GRANT wb_all TO buildd_armel GRANTED BY wbadm; +GRANT wb_all TO buildd_hppa GRANTED BY wbadm; +GRANT wb_all TO "buildd_hurd-i386" GRANTED BY wbadm; +GRANT wb_all TO buildd_i386 GRANTED BY wbadm; +GRANT wb_all TO buildd_ia64 GRANTED BY wbadm; +GRANT wb_all TO "buildd_kfreebsd-amd64" GRANTED BY wbadm; +GRANT wb_all TO "buildd_kfreebsd-i386" GRANTED BY wbadm; +GRANT wb_all TO buildd_mips GRANTED BY wbadm; +GRANT wb_all TO buildd_mipsel GRANTED BY wbadm; +GRANT wb_all TO buildd_powerpc GRANTED BY wbadm; +GRANT wb_all TO buildd_s390 GRANTED BY wbadm; +GRANT wb_all TO buildd_sparc GRANTED BY wbadm; +GRANT wb_all TO christoph GRANTED BY wbadm; +GRANT wb_all TO colint GRANTED BY wbadm; +GRANT wb_all TO dannf GRANTED BY wbadm; +GRANT wb_all TO fs GRANTED BY wbadm; +GRANT wb_all TO glondu GRANTED BY wbadm; +GRANT wb_all TO he 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 lamont GRANTED BY wbadm; +GRANT wb_all TO luk GRANTED BY wbadm; +GRANT wb_all TO mbanck GRANTED BY wbadm; GRANT wb_all TO mehdi GRANTED BY wbadm; GRANT wb_all TO nomeata GRANTED BY wbadm; +GRANT wb_all TO p2 GRANTED BY wbadm; +GRANT wb_all TO riku GRANTED BY wbadm; +GRANT wb_all TO sthibault GRANTED BY wbadm; GRANT wb_all TO vorlon GRANTED BY wbadm; +GRANT wb_all TO waldi GRANTED BY wbadm; GRANT wb_all TO wbadm GRANTED BY wbadm; +GRANT wb_all TO wookey GRANTED BY wbadm; +GRANT wb_all TO wouter GRANTED BY wbadm; GRANT wb_all TO zobel GRANTED BY wbadm; +GRANT wb_all TO zumbi 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; @@ -157,6 +219,7 @@ 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 pkern 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; @@ -164,5 +227,4 @@ 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;