[ http://issues.apache.org/jira/browse/DERBY-1522?page=comments#action_12424696 ] Deepa Remesh commented on DERBY-1522: -------------------------------------
I am covering a part of this in upgrade testing. I have a patch attached to DERBY-1521 which is pending review. In this patch, I have added a test to check that an upgraded database will support basic grant/revoke after switching to Derby SQL standard authorization. I am planning to add some more grant/revoke tests to be run after upgrade. However, I am wondering if we should also test this switch for databases created in 10.2 itself. I mean test that a database created in 10.2 without SQL standard authorization can be switched to SQL standard authorization. Maybe, the code paths are not different for the switch of an upgraded database and a 10.2 database ? In that case, we may not need this test. It would also be good to know what kind of test coverage is expected to test the "switch". > Switch(if supported) from Derby Authorization to Derby SQL Standard > Authorization needs to be tested > ---------------------------------------------------------------------------------------------------- > > Key: DERBY-1522 > URL: http://issues.apache.org/jira/browse/DERBY-1522 > Project: Derby > Issue Type: Task > Components: JDBC > Affects Versions: 10.2.0.0 > Reporter: Mamta A. Satoor > Fix For: 10.2.0.0 > > > There has been discussions on the Derby-dev list about switch from Derby > Authorization to Derby SQL Standard Authorization for existing databases. If > we do decide to support a switch like that, testing needs to be done/added to > make sure everything works fine after the switch. > ps I have added this JIRA entry to JDBC component but I am not 100% sure if > that is the right component. -- 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
