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 "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2007/10/18 13:50:51 UTC
[jira] Created: (DERBY-3133) Syntax for GRANT table permission does
nto mention that several privileges may be specified in a list
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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Attachment: derby3133_4.diff
Updated the patch and
Committed revision 592509.
> 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
> Fix For: 10.2.2.1, 10.2.3.0, 10.3.1.5
>
> 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537557 ]
Dag H. Wanvik commented on DERBY-3133:
--------------------------------------
Yes, I just fiddled with the html files; easier than explaining my point in detail.
Not sure if the dita let's you generate exactly that html ;)
> 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, rrefsqljgrant-2.html, rrefsqljgrant.html, rrefsqljrevoke-2.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.
[jira] Assigned: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart reassigned DERBY-3133:
------------------------------------
Assignee: Laura Stewart
> 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
>
> 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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Fix Version/s: 10.3.1.5
10.2.3.0
10.2.2.1
> 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
> Fix For: 10.2.2.1, 10.2.3.0, 10.3.1.5
>
> 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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Attachment: rrefsqljrevoke.html
rrefsqljgrant.html
derby3133_1.diff
I've made the updates to both GRANT and REVOKE.
I've attached the patch and both HTML files.
Please let me know if there is anything else to update here.
> 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, rrefsqljgrant.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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Derby Info: (was: [Patch Available])
> 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
> Fix For: 10.2.2.1, 10.2.3.0, 10.3.1.5
>
> 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.
[jira] Closed: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik closed DERBY-3133.
--------------------------------
Verified on trunk, closing. Thanks for fixing this, Laura!
> 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
> Fix For: 10.2.2.1, 10.2.3.0, 10.3.1.5
>
> 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536144 ]
Dag H. Wanvik commented on DERBY-3133:
--------------------------------------
The syntax for REVOKE (in rrefsqljrevoke) has the same issue.
> 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
>
> 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538622 ]
Dag H. Wanvik commented on DERBY-3133:
--------------------------------------
Thanks, Laura! Looks good now.
+1
If you want, you make change the singular form of privilege-type to plural privilege-types
since the production can specify more than one privilege.
Reading it again, I notice that the enclosing parentheses of column-list
might perhaps be called out by renaming that production to something
like "parenthesized-column-list", but I'll leave that decision to you.
> 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, rrefsqljgrant-2.html, rrefsqljgrant.html, rrefsqljgrant.html, rrefsqljrevoke-2.html, 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539176 ]
Laura Stewart commented on DERBY-3133:
--------------------------------------
Thanks for catching this !
I'll update the files and commit a new patch.
> 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, 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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-3133:
---------------------------------
Attachment: rrefsqljrevoke-2.html
rrefsqljgrant-2.html
Thanks, Laura! I adjusted the syntax layout a bit, please have a look
at the version I uploaded:
- I let all non-terminals have a section, so the font comes out the same
- eliminated some superfluous brace groupers (it came out a bit wrong in the initial version)
- changed "privilege-type" to "privilege-types" to reflect new reality (I forgot that in my first proposal)
Let me know what you think!
> 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, rrefsqljgrant-2.html, rrefsqljgrant.html, rrefsqljrevoke-2.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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Attachment: rrefsqljrevoke.html
rrefsqljgrant.html
derby3133_2.diff
Updated patch and html files to match the changes Dag recommended.
Please let me know if these are ready to commit.
> 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, rrefsqljgrant-2.html, rrefsqljgrant.html, rrefsqljgrant.html, rrefsqljrevoke-2.html, 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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dag H. Wanvik updated DERBY-3133:
---------------------------------
Summary: Syntax for GRANT table permission does not mention that several privileges may be specified in a list (was: Syntax for GRANT table permission does nto mention that several privileges may be specified in a list)
> 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
> 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537369 ]
Laura Stewart commented on DERBY-3133:
--------------------------------------
Dag - Your changes look good, much cleaner.
You updated only the html files yes?
I will need to retrofit these changes to the dita source files.
It may take me a try or two to get the source to generate the output like you have it in the html...
> 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, rrefsqljgrant-2.html, rrefsqljgrant.html, rrefsqljrevoke-2.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.
[jira] Resolved: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Attachment: rrefsqljrevoke.dita
rrefsqljgrant.dita
derby3133_3.diff
Dag - I made the update to the privileges label but I think that the recommendation about
the column list is not necessary, The syntax shows what is needed.
> 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, 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538786 ]
Kim Haase commented on DERBY-3133:
----------------------------------
The fixes are excellent, but there is a slight problem -- the new privilege-type cross-reference in the REVOKE page does not work, though the one in the GRANT page does.
The xref is to "revokeptype":
<xref href="rrefsqljrevoke.dita#rrefsqljrevoke/revokeptype">privilege-type</xref>
But the id is "revokeprivtype":
<section id="revokeprivtype"><title>privilege-types</title>
On the GRANT page the name is "grantprivtype" in both cases.
> 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, 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.
[jira] Commented: (DERBY-3133) Syntax for GRANT table permission
does not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538633 ]
Laura Stewart commented on DERBY-3133:
--------------------------------------
Committed revision 589907.
> 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, 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.
[jira] Updated: (DERBY-3133) Syntax for GRANT table permission does
not mention that several privileges may be specified in a list
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Laura Stewart updated DERBY-3133:
---------------------------------
Derby Info: [Patch Available]
> 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, rrefsqljgrant.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.