Re: [Maria-developers] Proposal for Negative Grants Project

2018-06-04 Thread Sergei Golubchik
Hi, Vicențiu! On May 31, Vicențiu Ciorbaru wrote: > > As you might've guessed from my comments above, I'd rather prefer to > > use REVOKE instead of DENY, if we can make it to work (and to > > explain how it works afterwards :). > > > > So here I suggest a semantics how REVOKE could be used for

Re: [Maria-developers] Proposal for Negative Grants Project

2018-05-31 Thread Vicențiu Ciorbaru
Hi Sergey! On Tue, 29 May 2018 at 17:54 Sergei Golubchik wrote: > Hi, Vicențiu! As you might've guessed from my comments above, I'd rather prefer to use > REVOKE instead of DENY, if we can make it to work (and to explain how it > works afterwards :). > > So here I suggest a semantics how

Re: [Maria-developers] Proposal for Negative Grants Project

2018-05-29 Thread Sergei Golubchik
Hi, Vicențiu! On May 12, Vicențiu Ciorbaru wrote: > > > > Random thoughts: > > > > * It's good that SQL Server supports DENY statement, a precedent is > > a very strong argument for us to do it that way. > > > > * I wasn't able to find any other database that has this functionality. > > (but many

Re: [Maria-developers] Proposal for Negative Grants Project

2018-05-12 Thread Rutuja Surve
Hi, Thanks a lot for reviewing the approach. I'll surely update MDEV-14443 with these ideas. We could follow either of the two approaches mentioned by Vicentiu above (argument for duplication of tables or modification of the primary key definition for including an extra is_deny column to avoid

Re: [Maria-developers] Proposal for Negative Grants Project

2018-05-12 Thread Vicențiu Ciorbaru
Hi Sergei! On Fri, 11 May 2018 at 21:10 Sergei Golubchik wrote: > Hi, Rutuja! > > I think it would've be useful to put your main ideas into MDEV-14443, as > a comment. > > For now I've just added a link to your email. > > On May 09, Rutuja Surve wrote: > > Hello, > > Please

Re: [Maria-developers] Proposal for Negative Grants Project

2018-05-11 Thread Sergei Golubchik
Hi, Rutuja! I think it would've be useful to put your main ideas into MDEV-14443, as a comment. For now I've just added a link to your email. On May 09, Rutuja Surve wrote: > Hello, > Please find the proposal for the Negative Grants project attached along > with this e-mail. It would be great

[Maria-developers] Proposal for Negative Grants Project

2018-05-09 Thread Rutuja Surve
Hello, Please find the proposal for the Negative Grants project attached along with this e-mail. It would be great to hear your opinions and suggestions on the approach proposed here, before delving into its implementation. Some context about the project: *The current privilege system allows