db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manjula G Kutty <manjula.ku...@gmail.com>
Subject Question on Grant/Revoke
Date Wed, 30 Aug 2006 23:15:19 GMT

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'.

So now the question is why the DBUSER need a select permission here??


View raw message