This patch should address these two left over items in GRANT/REVOKE implementation. Some implementation notes:
1) Now Derby raises an SQLWarning when SQL authorization is ON without authentication at connect time. This is done by checking if AuthenticationService being used is an instance of NoneAuthenticationServiceImpl. Since this is the default authentication service with Derby, it should always be present.
2) Added code to drop permission descriptors from SYSTABLEPERMS, SYSCOLPERMS and SYSROUTINEPERMS when the object they provide permission for is dropped. This includes tables, views and routines and these descriptors needs to be removed from permissionCache as well.
I have tested the cases when PermissionsDescriptors are in cache also.
Passed GrantRevoke tests. Will run derbyAll tonight and submit changes over the weekend.