pgsql: Allow GRANTED BY clause in normal GRANT and REVOKE statements

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pgsql: Allow GRANTED BY clause in normal GRANT and REVOKE statements
Дата
Msg-id E1l5lyO-0004hY-1q@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Allow GRANTED BY clause in normal GRANT and REVOKE statements

The SQL standard allows a GRANTED BY clause on GRANT and
REVOKE (privilege) statements that can specify CURRENT_USER or
CURRENT_ROLE.  In PostgreSQL, both of these are the default behavior.
Since we already have all the parsing support for this for the
GRANT (role) statement, we might as well add basic support for this
for the privilege variant as well.  This allows us to check off SQL
feature T332.  In the future, perhaps more interesting things could be
done with this, too.

Reviewed-by: Simon Riggs <simon@2ndquadrant.com>
Discussion: https://www.postgresql.org/message-id/flat/f2feac44-b4c5-f38f-3699-2851d6a76dc9@2ndquadrant.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6aaaa76bb47db11cd6f567eafa3d1ee81ca59556

Modified Files
--------------
doc/src/sgml/ref/grant.sgml              | 25 ++++++++++++++++++++++---
doc/src/sgml/ref/revoke.sgml             | 13 +++++++++++++
src/backend/catalog/aclchk.c             | 16 ++++++++++++++++
src/backend/catalog/sql_features.txt     |  2 +-
src/backend/nodes/copyfuncs.c            |  1 +
src/backend/nodes/equalfuncs.c           |  1 +
src/backend/parser/gram.y                | 13 ++++++++-----
src/include/nodes/parsenodes.h           |  1 +
src/test/regress/expected/privileges.out |  6 ++++--
src/test/regress/sql/privileges.sql      |  6 ++++--
10 files changed, 71 insertions(+), 13 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: pgsql: Fix CREATE INDEX CONCURRENTLY for simultaneous prepared transact
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: doc: Clarify status of SELECT INTO on reference page