aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJoe Conway <mail@joeconway.com>2017-11-26 09:49:40 -0800
committerJoe Conway <mail@joeconway.com>2017-11-26 09:49:40 -0800
commit752714dd9de3d1b919d582ddaac96425a6cfa66d (patch)
treed97dd188418f9f2dad06bc17d4fcb1411b00b00a
parent6d4ae6a8e782d87ffb6aab62f75787b2722daa2d (diff)
downloadpostgresql-752714dd9de3d1b919d582ddaac96425a6cfa66d.tar.gz
postgresql-752714dd9de3d1b919d582ddaac96425a6cfa66d.zip
Make has_sequence_privilege support WITH GRANT OPTION
The various has_*_privilege() functions all support an optional WITH GRANT OPTION added to the supported privilege types to test whether the privilege is held with grant option. That is, all except has_sequence_privilege() variations. Fix that. Back-patch to all supported branches. Discussion: https://postgr.es/m/005147f6-8280-42e9-5a03-dd2c1e4397ef@joeconway.com
-rw-r--r--src/backend/utils/adt/acl.c3
1 files changed, 3 insertions, 0 deletions
diff --git a/src/backend/utils/adt/acl.c b/src/backend/utils/adt/acl.c
index fa6b792d008..2f2758fe91b 100644
--- a/src/backend/utils/adt/acl.c
+++ b/src/backend/utils/adt/acl.c
@@ -2242,8 +2242,11 @@ convert_sequence_priv_string(text *priv_type_text)
{
static const priv_map sequence_priv_map[] = {
{"USAGE", ACL_USAGE},
+ {"USAGE WITH GRANT OPTION", ACL_GRANT_OPTION_FOR(ACL_USAGE)},
{"SELECT", ACL_SELECT},
+ {"SELECT WITH GRANT OPTION", ACL_GRANT_OPTION_FOR(ACL_SELECT)},
{"UPDATE", ACL_UPDATE},
+ {"UPDATE WITH GRANT OPTION", ACL_GRANT_OPTION_FOR(ACL_UPDATE)},
{NULL, 0}
};