MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Aman Raheja Date:July 26 2004 4:10pm
Subject:Re: Re[2]: nested sets
View as plain text  
On Mon, 2004-07-26 at 10:24, DebugasRu wrote:
> Hello Aman,
> Monday, July 26, 2004, 6:03:07 PM, you wrote:
> >> Hello,
> >> 
> >> I have a question related to nested sets:
> >> 
> >> On my website a user should be able to create subusers and give them the
> >> rights to add/change/delete subsites of the users website. If I remove one
> >> or more rights to a user all of its subusers should have the same
> >> restrictions as the user. If I grant the rights to the user back all
> >> subusers should get their orginal rights
> AR> If, say there was a way, you could remove the c and d rights from
> AR> subsequent users by removing it from User2, I think you are talking
> AR> about some kind of history retention (or memory engine)
> I think he was talking about user roles.
> one creates a role and then assigns that role to the users.
> When one changes the role rights then automatically users' rights
> change according to the roles they have.

He didn't mention about roles. I have a similar implementation on my
website and let me explain the point I had, and would want Alexander to
point out if this is what he wants.
Consider he assigns the following
User2  a,c,d
-User3 a,c
-User4 c,d
-User5 a,d
-User6 c,d
-User7 d

If c is dropped from User2, it should look like
User2  a,d
-User3 a
-User4 d
-User5 a,d
-User6 d
-User7 d

Now if c is added back to User2, he wants to get Scene1 again. Would
this not mean that there should be some kind of storage which as follows

User2 c
User3 c
User4 c
User5 -
User6 c
User7 -
Such that on giving c to User2 would give the permissions as above to
I say this approach because what if Scene 2 is changed as follows at
some stage

User2  a,d
-User3 a
-User5 a,d
-User6 a
-User7 d

Now if we put back c to User2 don't we want User3, User4 and User6 to
get c normally - but now we won't be back to Scene1.

I would expect Alexander's input, to check if I am pointing in the right


nested setsAlexander Newald26 Jul
  • Re: nested setsAman Raheja26 Jul
    • Re[2]: nested setsDebugasRu26 Jul
      • Re: Re[2]: nested setsAman Raheja26 Jul
  • Re: Re[2]: nested setsAlexander Newald26 Jul
  • Re: Re[2]: nested setsAlexander Newald26 Jul
  • Re: Re[2]: nested sets - Perhaps a solution!Alexander Newald27 Jul