[CASSANDRA-17030] Allow to GRANT or REVOKE multiple permissions in a single statement

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.1-alpha1, 4.1
• Component/s: CQL/Syntax
• Change Category: Semantic
• Complexity: Low Hanging Fruit
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/185893256f10c14207bffe49ae733fb1a970aec5

Test and Documentation Plan

The patch add some tests to validate the syntax.

• Assignee: Francisco Guerrero
• Reporter: Benjamin Lerer

Authors

Francisco Guerrero

Reviewers

Benjamin Lerer, Yifan Cai

• Created: 08/Oct/21 17:32
• Updated: 27/May/22 19:25
• Resolved: 22/Oct/21 12:50

Description

In order to GRANT or REVOKE multiple permissions we are currently forced to execute multiple requests. For example:

GRANT MODIFY ON KEYSPACE field TO manager;
GRANT SELECT ON KEYSPACE field TO manager;

We should be able to perform the same operations on a single request

GRANT MODIFY, SELECT ON KEYSPACE field TO manager;