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

Reply via email to