db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6121) Regularize how we refer to object names in the Reference Manual sections on GRANT/REVOKE
Date Wed, 11 Sep 2013 20:28:52 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13764721#comment-13764721

Kim Haase commented on DERBY-6121:

This issue affects more than the GRANT and REVOKE statements, and could lead to quite a few
consistency fixes.

Several CREATE statement topics specify the syntax for the created object in the topic itself
rather than in a separate topic under "SQL identifiers." These include

CREATE TYPE statement

I can create separate object-Name topics for each of these. Most of the existing topics have
hyphens but some don't -- table-Name vs. schemaName, RoleName, etc. I may as well hyphenate
the new ones.

It would probably be helpful to alphabetize the topics under "SQL identifiers." The current
order seems semi-random.

Some of the syntax for other statement topics can then be regularized as well, in addition
to that for GRANT and REVOKE.

> 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:
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
> This issue came up during the buddy testing of user-defined aggregates. Here's what Dag
>     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
>       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

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

View raw message