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
araheja@stripped Brainbench Certified Linux (General) Admin
www.TechQuotes.com Brainbench Certified Linux (RedHat 9) Admin
