[Q] UPDATE permissions

Hi, is having Update permissions not enough to modify data ? I found that users having granted update permission via role cannot modify table data unless update statement is issued with no where clause. The error number is ` -272 No SELECT permissions' (why select ?). Note such bevahior disagrees with Guide to SQL - Tutorial, p.10-9, which says `...grant Update privilege to make users to be able update rows... . However, you might grant Select privilege to only few users.' So, the questions are: 1. Is Select privilege required to make users to be able to modify any row? 2. Is the bevavior server-specific? Tested was IDS 7.22 for SCO UNIX, non-ANSI mode. Thanks. -- S.Oleshko International Data Systems sol@ids.lviv.ua