postgres.git / summary / log / commit / refs

commit    997015ef231ac4b5aac6a2437e5fa8eaac253fbb
Author:   Joe Conway <mail@joeconway.com>
Date:     Sun Nov 26 17:50:15 2017 +0000
First released in: 11.0, 9.3.21, 9.4.16, 9.5.11, 9.6.7, 10.2

    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


src/backend/utils/adt/acl.c | 3 +++ 1 file changed, 3 insertions(+) diff --git a/src/backend/utils/adt/acl.c b/src/backend/utils/adt/acl.c index 061d71edf8e..be70cc0409a 100644 --- a/src/backend/utils/adt/acl.c +++ b/src/backend/utils/adt/acl.c @@ -2244,8 +2244,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} }; [parent: cd3bde814612]