db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1521) Upgrade test needs to be enhanced to test grant revoke
Date Fri, 21 Jul 2006 16:39:14 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1521?page=all ]

Deepa Remesh updated DERBY-1521:

    Attachment: d1521-patch1-v1.diff

Attaching a patch 'd1521-patch1-v1.diff' which modifies UpgradeTester to test the grant/revoke
feature. This is a preliminary patch which tests the default upgrade behaviour: In  upgrades
from versions earlier than 10.2,
* grant/revoke feature is not available in soft upgrade
* grant/revoke feature is not available in full upgrade (by default). This feature will be
available after full upgrade only if "derby.database.sqlAuthorization" is true.

The patch adds a method to UpgradeTester to test grant/revoke feature. This method currently
checks that grant/revoke feature is not supported by issuing a grant command. I think we need
to add more checks to this method. 

With this patch, I ran the upgrade test with sane classes and jars. This patch modifies only
upgrade test. Please review/commit this patch if okay.

As I mentioned before, this is a preliminary patch. More changes planned in subsequent patch(es):
* Test upgrade with derby.database.sqlAuthorization set
* Add more checks to see grant/revoke feature not supported.
  - grant/revoke not available on existing databases if derby.database.sqlAuthorization was
not set to true during upgrade.
* Add basic tests to test grant/revoke feature works when upgraded with derby.database.sqlAuthorization
set to true
  - grant/revoke works on the upgraded database
  - owner of system schemas is changed from pseudo user 'DBA' to the authorizationID of the
user invoking upgrade
  - check contents of new system tables related to grant/revoke
  - check that all tables and views will be owned by the database owner after upgrade.
  - check if it is better to add few basic tests to UpgradeTester or cover the testing by
calling an existing grant/revoke test

Do we need to cover anything else in the testing? 

> Upgrade test needs to be enhanced to test grant revoke
> ------------------------------------------------------
>                 Key: DERBY-1521
>                 URL: http://issues.apache.org/jira/browse/DERBY-1521
>             Project: Derby
>          Issue Type: Improvement
>          Components: Test
>    Affects Versions:
>            Reporter: Mamta A. Satoor
>         Assigned To: Deepa Remesh
>             Fix For:
>         Attachments: d1521-patch1-v1.diff, d1521-patch1-v1.status
> Grant Revoke is one of the features targeted for 10.2 Release. The upgrade test should
be modified to test this feature with various upgrade scenarios to make sure everything works

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