[Aman's view of my problem] Hi,
I think you know what my problem is. My "solution" so far is (from another mail): -- snip -- The main problem I have to do the "rollback". A 2nd table is no option because it might be possible that another users rights get be change before the rights of the first user has been restored. Using +---------+---------+--------------------+-----+-----+----+----+----+ | node_id | root_id | user | lft | rgt | a | c | d | +---------+---------+--------------------+-----+-----+----+----+----+ | 1 | 1 | User1 | 1 | 4 | 1 | 0 | 0 | +---------+---------+--------------------+-----+-----+----+----+----+ | 2 | 1 | User2 | 2 | 3 | 1 | 1 | 1 | +---------+---------+--------------------+-----+-----+----+----+----+ and using 1 or 0 for the a, c and d col would give the rights to the users. But how to check if the rights of the "parent" user do not are lower? In the exmaple above how to get 0 for c and d for User2 (because User2 is a subuser of User1)? -- snip -- Look's like this is a really big problem!? Alexander Newald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
