Re: [Q] UPDATE permissions

June Tong wrote: > Sergey Oleshko wrote: > > > 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 ?). > > UPDATE personnel SET lname = lname WHERE lname = 'Akins' AND salary > 100000> If it says "0 rows updated." then I know that Akins makes < 100000. > > June > -- > june_t@hotmail.com > Lost in the wilds of Palo Alto, living on Peanut M&M's I have to admin Miss June that You have inspired me to RTFM. So I have found some explantion of flags in systabauth. There is written that update permission is just permission to do unconditionally update I think that Your example of abusing UPDATE to do some SELECT plus this excerption from TFM answers the questions of Mr Sergey Oleshko. - the excerption from manual - anwsers why it (I mean Informix, maybe i should write It -:)) behaved as it did. - Your example - explains why people from Informix decided to implement this this way (they did right and thanks them for this). -- #ifdef LANGUAGE=POLISH | Unix Adm & Dev, Informix Adm & Dev #include <wyrazy_szacunku.h> | Pure HTML Coder, Win32 API Dev #else #include <greetings.h> #endif