From: Joe Conway <mail@joeconway.com>
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Subject: has_sequence_privilege() never got the memo
Date: Wed, 22 Nov 2017 18:01:38 -0800
Message-ID: <005147f6-8280-42e9-5a03-dd2c1e4397ef@joeconway.com> (raw)
I just noticed that has_sequence_privilege() never got the memo about
"WITH GRANT OPTION". Any objections to the attached going back to all
supported versions?
Joe
--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development
Attachments:2017.11.22.000-seq_privs-missing_grantopt.diff (text/x-patch, 623B) downloaddiff --git a/src/backend/utils/adt/acl.c b/src/backend/utils/adt/acl.cindex fa6b792..2f2758f 100644
*** a/src/backend/utils/adt/acl.c
--- b/src/backend/utils/adt/acl.c
*************** convert_sequence_priv_string(text *priv_
*** 2242,2249 ****
--- 2242,2252 ----
{
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}
};
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-hackers@postgresql.org
Cc: mail@joeconway.com
Subject: Re: has_sequence_privilege() never got the memo
In-Reply-To: <005147f6-8280-42e9-5a03-dd2c1e4397ef@joeconway.com>
References: <005147f6-8280-42e9-5a03-dd2c1e4397ef@joeconway.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox