db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <banda...@gmail.com>
Subject Disabling non-SELECT privileges for VIEWs ...
Date Fri, 28 Jul 2006 18:56:45 GMT
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



Mime
View raw message