db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta Satoor" <msat...@gmail.com>
Subject Re: Question on Grant/Revoke
Date Thu, 31 Aug 2006 14:45:21 GMT
Manjula, I haven't looked at the SQL spec but it looks like that the update
statement is doing a select operation on the column id with "where id=3" and
that is what is causing Derby to send an error.

Mamta


On 8/30/06, Manjula G Kutty <manjula.kutty@gmail.com> wrote:
>
> 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
>
>
>

Mime
View raw message