X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate79.py;h=ca20450e6c770b313a5d59c74d15da65ce968893;hb=61d1e2b14d61c045dcc07cd177dec49af0c41c45;hp=954f393d45858cc52e34f87529abda1d71fc53cd;hpb=54903526ea5f9cd14103bcd3d312683e004c94d4;p=dak.git diff --git a/dak/dakdb/update79.py b/dak/dakdb/update79.py old mode 100644 new mode 100755 index 954f393d..ca20450e --- a/dak/dakdb/update79.py +++ b/dak/dakdb/update79.py @@ -38,6 +38,7 @@ def do_update(self): c = self.db.cursor() c.execute("CREATE SCHEMA world"); + c.execute("GRANT USAGE ON SCHEMA workd TO PUBLIC") c.execute("ALTER DEFAULT PRIVILEGES IN SCHEMA world GRANT SELECT ON TABLES TO PUBLIC") c.execute("ALTER DEFAULT PRIVILEGES IN SCHEMA world GRANT ALL ON TABLES TO ftpmaster") c.execute("ALTER DEFAULT PRIVILEGES IN SCHEMA world GRANT SELECT ON SEQUENCES TO PUBLIC")