[DERBY-3133] Syntax for GRANT table permission does not mention that several privileges may be specified in a list

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.4.1.3
• Fix Version/s: 10.2.2.1, 10.3.2.1
• Component/s: Documentation
• Assignee: Laura Stewart
• Reporter: Dag H. Wanvik
• Created: 18/Oct/07 11:50
• Updated: 05/Jul/10 17:12
• Resolved: 06/Nov/07 18:23

Description

The syntax is currently specified (in rrefsqljgrant) as:

> GRANT privilege-type ON [TABLE]

{ table-Name | view-Name } TO grantees
>
> privilege-type
>
> { > ALL PRIVILEGES | > DELETE | > INSERT | > REFERENCES [column list] | > SELECT [column list] | > TRIGGER | > UPDATE [column list}
> }

Derby, however, accepts a list of privilege type (see code in
sqlgrammar#tableActions), if the type is not "ALL PRIVILEGES".

Furthermore, column-list is not expanded; it should be because it
needs surrounding parentheses (i.e. it is not just a plain list).

So, the doc for granting table permissions should read something like:

Syntax for tables

GRANT privilege-type ON [TABLE] { table-Name | view-Name }

TO grantees

privilege-type

ALL PRIVILEGES |
privilege-list

privilege-list
table-privilege

{, table-privilege }

*

Table-privilege

DELETE |
INSERT |
REFERENCES [column-list] |
SELECT [column-list] |
TRIGGER |
UPDATE [column-list}

column-list
( column-identifier

{, column-identifier}

* )