From: Joerg Jaspert Date: Sun, 12 Aug 2012 12:53:29 +0000 (+0200) Subject: grant usage for world X-Git-Url: https://git.decadent.org.uk/gitweb/?p=dak.git;a=commitdiff_plain;h=5ddafaf05a99011595ea3ef2b80f4385b52a9cc8 grant usage for world Signed-off-by: Joerg Jaspert --- 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")