Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Tue, 28 Mar 2006 14:59:01 -0800
From: Michelle Caisse <Michelle.Caisse@Sun.COM>
Subject: Re: Looking for good test suite to test Grant & Revoke functionality
 ...
In-reply-to: <4424BA72.6080108@Sourcery.Org>
To: derby-dev@db.apache.org
Message-id: <4429BFB5.9080104@sun.com>
MIME-version: 1.0
Content-type: multipart/alternative;
 boundary="Boundary_(ID_Gyz0R6PU5UjKI4tAcPJFOA)"
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2)
 Gecko/20040803
References: <4424BA72.6080108@Sourcery.Org>

This is a multi-part message in MIME format.

--Boundary_(ID_Gyz0R6PU5UjKI4tAcPJFOA)
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT

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


--Boundary_(ID_Gyz0R6PU5UjKI4tAcPJFOA)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: 7BIT

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Satheesh,<br>
<br>
I've attached some code to DERBY-464 that may be useful as the basis of
a grant/revoke test.&nbsp; It comes from the Sun HADB test suite.&nbsp; If you
decide to use it, let me know if you need any of the classes it depends
on.<br>
<br>
-- Michelle<br>
<br>
Satheesh Bandaram wrote:<br>
<blockquote cite="mid4424BA72.6080108@Sourcery.Org" type="cite">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
As I am wrapping up Grant &amp; 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:<br>
  <ol>
    <li>Try converting existings tests to new SQL authorization mode. <b>nist
      </b>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<b> 40</b> 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.</li>
    <li>Import a suitable test in open source world with compatible
license. Any ideas here?</li>
    <li>Write one from scratch. Might take reasonable amount of time.</li>
  </ol>
Thanks for any suggestions,<br>
  <br>
Satheesh <br>
</blockquote>
<br>
</body>
</html>

--Boundary_(ID_Gyz0R6PU5UjKI4tAcPJFOA)--