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 Scene1 ---------------- 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 Scene2 ---------------- 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 others. I say this approach because what if Scene 2 is changed as follows at some stage Scene3 ----------------- User2 a,d -User3 a -User4 -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 direction. Regards Aman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
