[ http://issues.apache.org/jira/browse/DERBY-1521?page=comments#action_12423744 ] Satheesh Bandaram commented on DERBY-1521: ------------------------------------------
I seem to have missed one of Dan's questions about GRANT & REVOKE in this entry: " * Add basic tests to test grant/revoke feature works when upgraded with derby.database.sqlAuthorization set to true - owner of system schemas is changed from pseudo user 'DBA' to the authorizationID of the user invoking upgrade ----------------- Does this step happen regardless of the value of the property derby.database.sqlAuthorization? " Yes... Current code is implemented such that authorizationID of the owner is recorded in system catalog for system schemas regardless of the value of property derby.database.sqlAuthorization. Updating system schema owner name during upgrade would facilitate switching over to SQL authorization mode later. In Derby authorization mode, this value is not used anyway. > 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: 10.2.0.0 > Reporter: Mamta A. Satoor > Assigned To: Deepa Remesh > Fix For: 10.2.0.0 > > 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 fine. -- 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
