The design problem of giving multiple permissions to tree-structured objects

requirements:
Select a user and select one or some items in the tree object to give the user multiple permissions to operate on the selected object.
permission type is one or more of the additions, deletions, queries and modifications. The structure of the object is as follows, and the tree control used is ztree.

clipboard.png


:
1select

2:

clipboard.png

disadvantages (it will look ugly if there are more than one object)

effect you want to achieve
you want to show the relationship between an object and multiple permission types in a better way, preferably if the user can edit it while viewing the existing permissions.

Apr.07,2021

use tree table

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eb0f7a-2319.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1eb0f7a-2319.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?