db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Date Fri, 15 Sep 2006 17:39:24 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435062 ] 
Mamta A. Satoor commented on DERBY-1839:

The page for CREATE VIEW rrefsqlj15446.html has following information
"If the view owner have been granted following privileges on all objects used by the view,
then the view owner automatically gains ability to grant the SELECT privilege to other users:
SELECT for columns used from all referenced tables and views 
EXECUTE for all functions used 
The privilege to grant the SELECT privilege cannot be revoked. However if a subsequent REVOKE
statement revokes one of the privileges that have been granted, the ability to grant privileges
to other users is implicitly revoked."

I think after Yip's changes for DERBY-1686, the above information is incorrect. A view owner
cannot grant SELECT privileges on the view to other users if view owner does own all the underlying
objects referenced by the view.

> 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:
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>         Attachments: 1839_SQLstatements.diff, 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


View raw message