[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436045 ] Yip Ng commented on DERBY-1839: -------------------------------
For CREATE VIEW: "The view owner can only grant the SELECT privilege to other users if the view owner also owns the underlying objects." I think this sounds fine. Similarly, you may want to also mention that in order to create a view successfully in SQL Authorization mode, the view owner needs to have the proper privileges given to him/her if the underlying objects that the view references are not own by the view owner. e.g.: if the authorization id user2 attempts to create a view called user2.v2 that references table user1.t1 and function user1.f_abs(). user2 must have SELECT privilege on user1.t1 and EXECUTE privilege on user1.f_abs(). user2: CREATE VIEW user2.v2 as SELECT i, user1.f_abs(j) from user1.t1; > 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
