Hi,
I was testing the new grant/revoke feature and now have this question.
Here is what I did
ij> connect 'jdbc:derby:testdb;create=true' user 'DBADMIN' password 'admin';
ij> create table t1 (id int, name char(100));
0 rows inserted/updated/deleted
ij> insert into t1 values (1,'sss'),(2, 'bbb'),(3, 'kkk');
3 rows inserted/updated/deleted
ij> grant update on t1 to DBUSER;
0 rows inserted/updated/deleted
ij> connect 'jdbc:derby:testdb' user 'DBUSER' password 'user';
ij(CONNECTION1)> update DBADMIN.t1 set id =1 where id=3;
ERROR 28508: User 'DBUSER' does not have select permission on column
'ID' of tab
le 'DBADMIN'.'T1'.
ij(CONNECTION1)>
So now the question is why the DBUSER need a select permission here??
Thanks
Manjula
