db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Date Tue, 19 Sep 2006 18:13:23 GMT
    [ 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

        

Mime
View raw message