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 Thu, 21 Sep 2006 17:36:23 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436589 ] 
            
Mamta A. Satoor commented on DERBY-1839:
----------------------------------------

I have couple few comments on derby1839_SQLstatements3_htiml.zip 
1)"CREATE VIEW statement" page has following line 
"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."

This does not sound correct to me. If a subsequent REVOKE statement revokes one of the privileges
that have been granted, then the view will drop automatically and hence the statement "the
ability to grant privileges to other users is implicitly revoked." is incorrect. If a required
privilege on one of the objects referenced by the view owner is revoked, then the view can't
exist anymore and will be dropped.

2)"LOCK TABLE STATEMENT" page has following line
"To lock a table, you must either be the database owner or have authorization to the schema
that the table uses."
I think it will be easier to understand if we said
"To lock a table, you must either be the database owner or the table owner."

Same comment for "RENAME TABLE statement" page

3)On the "CREATE TRIGGER statement" page, we do not say that database owner can create the
trigger on any table in any schema. We have that information about the database owner on other
CREATE statement pages.





> 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_SQLstatements3.diff, derby1839_SQLstatements3_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