[
http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435957 ]
Yip Ng commented on DERBY-1839:
-------------------------------
As Mamta pointed out with the CREATE VIEW doc comment, the following statement
is no longer true with the work of DERBY-1686:
<snip>
The view owner automatically gains the ability to grant the SELECT privilege to
other users if the view owner is granted the following privileges on all
objects used by the view:
* The privilege to grant SELECT for columns used from all referenced tables
and views
* The privilege to grant EXECUTE for all functions used
</snip>
Currentlly, the view owner can only grant the SELECT privilege to other users
provided that the underlying objects are also owned by the view owner. (or
that the view owner have been granted with grantable privileges on those
objects but since Derby does not support WITH GRANT OPTION, this does not apply
to the 10.2 release.)
> Doc Review Updates - Ref Manual
> -------------------------------
>
> Key: DERBY-1839
> URL: http://issues.apache.org/jira/browse/DERBY-1839
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.2.0
> Reporter: Laura Stewart
> Assigned To: Laura Stewart
> Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff,
> derby1839_SQLstatements2_html.zip, derby1839_SQLstatements_html.zip
>
>
> This JIRA issue will be used to track all of the issues found in the 10.2 doc
> review of the Reference Manual.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
