[ 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: 10.2.2.0 > 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
