I noticed Derby currently allows granting non-SELECT privileges to VIEWs. I will checks to disable this and add some tests.
Satheesh ij> create view myView as select * from newTab; 0 rows inserted/updated/deleted ij> grant *insert *on myView to Sammy; 0 rows inserted/updated/deleted ij> grant *delete *on myView to sammy; 0 rows inserted/updated/deleted ij> grant *references *on myView to sammy; 0 rows inserted/updated/deleted
