You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Laura Stewart (JIRA)" <ji...@apache.org> on 2007/11/06 19:24:51 UTC
[jira] Resolved: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart resolved DERBY-3133.
----------------------------------
Resolution: Fixed
> Syntax for GRANT table permission does not 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.2.1.6, 10.2.2.0, 10.3.1.4, 10.4.0.0
> Reporter: Dag H. Wanvik
> Assignee: Laura Stewart
> Priority: Minor
> Attachments: derby3133_1.diff, derby3133_2.diff, derby3133_3.diff, derby3133_4.diff, rrefsqljgrant-2.html, rrefsqljgrant.dita, rrefsqljgrant.html, rrefsqljgrant.html, rrefsqljrevoke-2.html, rrefsqljrevoke.dita, rrefsqljrevoke.html, rrefsqljrevoke.html
>
>
> 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.