On 09/30/2015 03:56 AM, Claudio Valderrama C. wrote: >> -----Original Message----- >> From: Alex Peshkoff [mailto:peshk...@mail.ru] >> Sent: Martes, 29 de Septiembre de 2015 8:01 >> So what should be better done: >> 1. Keep it as is >> 2. Add an option to revoke granted by ABC rights too > Is there anything in the SQL standard describing such situation?
No. revoke all on all is non-standard operator. > If not, I would prefer a cascade option. BTW, does this discussion include > undoing grants WITH ADMIN OPTION? I do not see differences in our code for Admin/Grant options except Admin is used for roles, but Grant - for all the rest. A number of questions raise here. For example - what about oracle which does not cascade-delete privileges granted with admin option. Not ready to answer them right now. ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel