Hi Though I would like to look up a way to implement what you want in MySQL, one thing was indicative and I wanted to point out. If, say there was a way, you could remove the c and d rights from subsequent users by removing it from User2, I think you are talking about some kind of history retention (or memory engine) if you want everything should be as before when you give the rights c and d to the User2 such that everything is as before (there is no default restoration but as it previously was) - you need to do some programming and need to have another table to store the history as I view it.
HTH a bit! On Mon, 2004-07-26 at 09:46, Alexander Newald 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 > > Example > > root > - User 1 a c d > - User 2 a c d > -- User 4 a c > -- User 5 a c d > --- User 7 a > --- User 8 a > -- User 6 a c d > - User 3 a c > > a = add, c = change, d = delete > > Now I like to give User 2 the rights for adding (a) only: > > User should see their rights as > > root > - User 1 a c d > - User 2 a > -- User 4 a c > -- User 5 a c d > --- User 7 a > --- User 8 a > -- User 6 a c d > - User 3 a c > > but/and effective rights should be > > root > - User 1 a c d > - User 2 a > -- User 4 a > -- User 5 a > --- User 7 a > --- User 8 a > -- User 6 a > - User 3 a c > > If I give back full rights to User 2 all should be like at the beginning > > Any help is welcome! > > Alexander Newald -- Aman Raheja Linux+ Certified [EMAIL PROTECTED] Brainbench Certified Linux (General) Admin www.TechQuotes.com Brainbench Certified Linux (RedHat 9) Admin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
