Syntax for GRANT table permission does nto mention that several privileges may
be specified in a list
-----------------------------------------------------------------------------------------------------
Key: DERBY-3133
URL: https://issues.apache.org/jira/browse/DERBY-3133
Project: Derby
Issue Type: Bug
Components: Documentation
Affects Versions: 10.3.1.4, 10.2.2.0, 10.2.1.6, 10.4.0.0
Reporter: Dag H. Wanvik
Priority: Minor
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}* )
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
