db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Date Tue, 19 Sep 2006 19:51:26 GMT
    [ 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:
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>         Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_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