From 1a96143b740f0c8b73f207d6f1bb9bc23d267553 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 5 Oct 2023 17:24:31 +0000 Subject: [PATCH] Add additional PostgreSQL ACL permission decoding https://www.postgresql.org/docs/current/ddl-priv.html#PRIVILEGE-ABBREVS-TABLE --- cookbooks/postgresql/libraries/postgresql.rb | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/cookbooks/postgresql/libraries/postgresql.rb b/cookbooks/postgresql/libraries/postgresql.rb index 9a53331dd..e26c94ade 100644 --- a/cookbooks/postgresql/libraries/postgresql.rb +++ b/cookbooks/postgresql/libraries/postgresql.rb @@ -149,8 +149,10 @@ module OpenStreetMap user = "public" if user == "" permissions[user] = { - "a" => :insert, "r" => :select, "w" => :update, "d" => :delete, - "D" => :truncate, "x" => :references, "t" => :trigger + "r" => :select, "a" => :insert, "w" => :update, "d" => :delete, + "D" => :truncate, "x" => :references, "t" => :trigger, + "C" => :create, "c" => :connect, "T" => :temporary, + "X" => :execute, "U" => :usage, "s" => :set, "A" => :alter_system }.values_at(*privileges.chars).compact end end -- 2.39.5