db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4522) Document SELECT statement requirements resulting from fix to DERBY-4191
Date Mon, 01 Feb 2010 22:49:19 GMT

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

Dag H. Wanvik commented on DERBY-4522:
--------------------------------------

Great to get this documented! Two comments:

-  I think this information should also be present in the GRANT statement topic, in the paragraph
that describes SELECT privilege (the one that starts with "Use the SELECT privilege type to
grant permission...").

- Another thing is that in this section in the GRANT topic, the privilege requirements for
SELECT is described as necessary for the *SELECT statement*. Surely, they are also necessary
for the *SELECT expression* (as hinted at to by the sentence mentioning subqueries in the
patch's addition to rrefsqlj41360). I think it should be possible to find the required privilege
information also when looking at the *SELECT expression* topic, which is the syntax form used
in an INSERT statement.  If the required privilege information is also explained in the SELECT
expression topic, the extra mention of subqueries would be redundant in the patch. Also, the
wording should start:

"For queries that do not select a specific column from the tables involved in the SELECT statement
or expression, ...."



> Document SELECT statement requirements resulting from fix to DERBY-4191
> -----------------------------------------------------------------------
>
>                 Key: DERBY-4522
>                 URL: https://issues.apache.org/jira/browse/DERBY-4522
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.4.2.0, 10.5.3.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>         Attachments: DERBY-4522.diff, rrefsqlj41360.html
>
>
> The SELECT statement topic needs language based on this release note:
> "Make sure that user has at least one column level select privilege or table level select
privilege for queries that do not select a specific column from the tables involved in the
SELECT statement. Additionally, subqueries will require that the user has necessary select
privileges in order to execute it."

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message