On 09/29/2015 01:11 PM, Paul Vinkenoog wrote: > Alex Peshkoff wrote: > >> Please look at this trivial sample. >> >> create table t (f int); >> grant select on t to public granted by abc; >> revoke all on all from abc; >> >> Currently privileges, granted by user ABC, remain as is after executing >> mentioned revoke operator. This looks like a bug for me, but before fixing >> (existing SQL operator behavior to be changed) I want to ask here - does >> anybody see problems with removing rights, granted by user, in subj? > Why is this a bug? 'Revoke all on all from abc' means to take away all rights > on any objects that were granted TO user ABC. IMO this should not imply that > any privileges granted to other users/roles BY user ABC are also withdrawn.
If all rights were revoked from ABC, how can rights, granted by him, remain in database? ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel