[ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12435984 ] Laura Stewart commented on DERBY-1839: --------------------------------------
Yip - For CREATE VIEW, is the following statements now accurate? Theview owner automatically gains the SELECT privilege on the view. The SELECT privilege cannot be revoked from the view owner. The database owner automatically gains the SELECT privilege on the view and is able to grant this privilege to other users. The SELECT privilege cannot be revoked from the database owner. The view owner can only grant the SELECT privilege to other users if the view owner also owns the underlying object. 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. > 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
