Alex Peshkoff wrote: > On 09/29/2015 03:23 PM, Dimitry Sibiryakov wrote: > > 29.09.2015 13:21, Paul Vinkenoog wrote: > >> So a CASCADE option would be a welcome addition for such cases. > > Another question: how many levels should this cascade go? > > > Unlimited, and about it will take care existing code - like it already > does when revoking grant option.
Been thinking some more about the entire REVOKE beheviour. A normal REVOKE cascades al the way. So either REVOKE ALL ON ALL should do the same (at least by default), or the standard REVOKE's behaviour should be changed. Either way (but especially in the former case) a [NO] CASCADE option that can be used with every REVOKE variant would be most welcome. Cheers, Paul Vinkenoog ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel