db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: DERBY-464 Grant/Revoke status
Date Thu, 24 Aug 2006 15:20:59 GMT
Thanks Mamta and Yip,

It turns out that Yip's list is pretty much Mamta's list of high 
priority NPEs plus the issues which already have patches. I have 
adjusted fix-in and urgency fields so that these features and bugs 
appear on the list of urgent 10.2 issues. It also seemed to me that 
DERBY-1522 exposed an important, untested code path so I bumped its 
ugency also.

That left DERBY-1521. From the comments on that issue, it appears that 
the code paths have been hand tested. However, I would feel better if 
this test were automated so I bumped the urgency of this JIRA as well. 
This one, however, is more like a stretch goal.

I hope this is acceptable to everyone.


Mamta Satoor wrote:

> I would like us to definitely tackle the grant-revoke related NPE bugs 
> in 10.2. Those bugs from the comprehensive list created by Yip are 
> DERBY-1589, DERBY-1583, DERBY-1724. The rest of the grant-revoke 
> usability bugs will be nice to fix too but in the worst case can be 
> documented in the 10.2 release notes.
> Mamta
> On 8/23/06, *Yip Ng* <yipng168@gmail.com <mailto:yipng168@gmail.com>> 
> wrote:
>     Here is a summary of the remaining open or in-progress JIRA issues
>     for DERBY-464 (Grant and Revoke).  It would be good to start
>     cleaning them up if some of these issues have already been
>     resolved to see where DERBY-464 currently is at.
>     New Feature:
>     DERBY-1539  A trigger should be dropped when a privilege required
>     by the trigger is revoked.
>     DERBY-1611  A view should be dropped when a privilege required by
>     the view is revoked.
>     DERBY-1612  A constraint should be dropped when a privilege
>     required by the constraint is revoked.
>     DERBY-1643  A "revoke execute ... restrict" should fail if there
>     are dependent objects on the execute privilege
>     DERBY-1646  Documentation to address Grant/Revoke Authorization
>     for views/triggers/constraints/routines(DERBY-1330)
>     Bug:
>     DERBY-1538  Unexpected behavior on self privilege revocation
>     DERBY-1582  REVOKE statement does not generate a warning when no
>     privileges are revoked.
>     DERBY-1583  With grant revoke enabled, defining a trigger whose
>     actions updates a table (from different schema) results in NPE
>     DERBY-1589  CREATE TABLE throws NullPointerException in Derby SQL
>     Standard Authorization after DROPs and REVOKES
>     DERBY-1686  Grant/Revoke: Attempt to GRANT access to another user
>     on a VIEW, created by the current user with only SELECT
>                          privilege on the base table does not fail
>     DERBY-1708  Unprivileged user can perform lock table statement on
>     a table which he/she does not have any access rights
>     DERBY-1716  Revoking select privilege from a user times out when
>     that user still have a cursor open.
>     DERBY-1724  Executing grant statement within a transaction leads
>     to a NPE later when the db owner attempts to update a table
>     DERBY-1729  Invoking Java stored procedure that contains GRANT or
>     REVOKE statement with CONTAINS SQL from a trigger should
>                          fail.
>     Sub-task:
>     DERBY-1330  Provide runtime privilege checking for grant/revoke
>     functionality
>     Task:
>     DERBY-1522  Switch(if supported) from Derby Authorization to Derby
>     SQL Standard Authorization needs to be tested
>     Improvement:
>     DERBY-1521  Upgrade test needs to be enhanced to test grant revoke 

View raw message