From ae782823eea6130f7251769120db60d7be22dd5c Mon Sep 17 00:00:00 2001 From: Debian wanna-build admins Date: Sat, 26 Feb 2011 15:12:52 +0000 Subject: [PATCH] Auto-committed schema changes. --- schema/roles.sql | 75 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 75 insertions(+) diff --git a/schema/roles.sql b/schema/roles.sql index c59eeb5..544e248 100644 --- 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; -- 2.39.2