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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2013/09/16 14:14:51 UTC
[jira] [Comment Edited] (DERBY-6121) Regularize how we refer to
object names in the Reference Manual sections on GRANT/REVOKE
[ https://issues.apache.org/jira/browse/DERBY-6121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13768266#comment-13768266 ]
Knut Anders Hatlen edited comment on DERBY-6121 at 9/16/13 12:12 PM:
---------------------------------------------------------------------
The latter looks cleaner to me, and they are equivalent as far as I can tell.
Another equivalent alternative is the following:
{noformat}
GRANT roleName { , roleName }* TO grantees
{noformat}
The square bracket style seems to be the more common one, though, used for example in FROM clause, GROUP BY clause, ORDER BY clause, USING clause. However, the curly style is used two more places in the GRANT statement topic; for privilege-list and column list. We might want to make them consistent.
Speaking of consistency, I wonder why "privilege-list" has a hyphen whereas "column list" has not.
[edit: added markup to prevent JIRA from garbling the syntax description]
was (Author: knutanders):
The latter looks cleaner to me, and they are equivalent as far as I can tell.
Another equivalent alternative is the following:
GRANT roleName { , roleName }* TO grantees
The square bracket style seems to be the more common one, though, used for example in FROM clause, GROUP BY clause, ORDER BY clause, USING clause. However, the curly style is used two more places in the GRANT statement topic; for privilege-list and column list. We might want to make them consistent.
Speaking of consistency, I wonder why "privilege-list" has a hyphen whereas "column list" has not.
> Regularize how we refer to object names in the Reference Manual sections on GRANT/REVOKE
> ----------------------------------------------------------------------------------------
>
> Key: DERBY-6121
> URL: https://issues.apache.org/jira/browse/DERBY-6121
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Rick Hillegas
> Assignee: Kim Haase
>
> This issue came up during the buddy testing of user-defined aggregates. Here's what Dag discovered:
> identifiers (seen when looking at GRANT USAGE of aggregates): "table-Name" occurences are linked to a section explainig them (rreftablename.html), but UDA names are defined in-lined as
> GRANT USAGE ON DERBY AGGREGATE [ schemaName. ] SQL92Identifier TO grantees
> In a third variant,
> GRANT EXECUTE ON { FUNCTION | PROCEDURE } routine-designator TO grantees
> routine-designator is defined locally as
> routine-designator { function-name | procedure-name }
> without links to what "function-name" or "procedure-name" might look like. It would be good to harmonize the latter two forms to a central definition as for "table-Name".
> Finally, I noted that the definition page for SchemaName doesn't link to the SQL92Identifier page...
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira