From 5ddafaf05a99011595ea3ef2b80f4385b52a9cc8 Mon Sep 17 00:00:00 2001 From: Joerg Jaspert Date: Sun, 12 Aug 2012 14:53:29 +0200 Subject: [PATCH] grant usage for world Signed-off-by: Joerg Jaspert --- dak/dakdb/update79.py | 1 + 1 file changed, 1 insertion(+) mode change 100644 => 100755 dak/dakdb/update79.py 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") -- 2.39.5