db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michelle Caisse <Michelle.Cai...@Sun.COM>
Subject Re: Looking for good test suite to test Grant & Revoke functionality ...
Date Tue, 28 Mar 2006 22:59:01 GMT
Hi Satheesh,

I've attached some code to DERBY-464 that may be useful as the basis of 
a grant/revoke test.  It comes from the Sun HADB test suite.  If you 
decide to use it, let me know if you need any of the classes it depends on.

-- Michelle

Satheesh Bandaram wrote:

> As I am wrapping up Grant & Revoke functionality being tracked under 
> DERBY-464 (except for views, triggers and constraints part), I am 
> looking for good way to test new functionality. While I have added two 
> new tests, grantRevokeDDL.sql and grantRevoke.java, I am looking to 
> expand test coverage to try some real schemas and usages. Some ideas are:
>    1. Try converting existings tests to new SQL authorization mode.
>       *nist *suite seems like a good candidate. It already enables
>       authentication and has authorization statements under comments.
>       I will have to change nist suite to grant required object
>       privileges and adjust test suite to work-around extra
>       restrictions current implementation has. I have already tried
>       running nist under SQL authorization and initial run caused
>       about* 40* test failures out of 126 tests. After changing tests
>       a little, I have brought down failures to about 20 tests. I will
>       need to further change tests to add grant statements to get the
>       test to pass.
>    2. Import a suitable test in open source world with compatible
>       license. Any ideas here?
>    3. Write one from scratch. Might take reasonable amount of time.
> Thanks for any suggestions,
> Satheesh

View raw message