it would be a great help to have a treeview with permissions.
It would make grating permissions - and keeping an overview of things - a lot easier, especially if you have a lot of tables. Speaking from experience: With 70+ tables, 13 usergroups, 60 users .. things get really complicated with the current version (AG v5.95).
The user should have the option to switch between several different views:
View 1: Tables with Groups
Code: Select all
Table A
+ - Group A Insert, View, Edit, Delete
+ - Group B Insert, View, Edit, Delete
Table B
+ - Group A Insert, View, Edit, Delete
+ - Group B Insert, View, Edit, Delete
Table C
+ - Group A Insert, View, Edit, Delete
+ - Group B Insert, View, Edit, Delete
Code: Select all
Table A
+- Insert
| + Group A
+- View
| + Group A
| + Group B
+- Edit
| + Group A
| + Group B
+- Delete
| + Group A
Table B
+- Insert
| + Group B
+- View
| + Group A
| + Group B
+- Edit
|+ Group A
|+ Group B
+- Delete
|+ Group A
|+ Group B
Table C
+- Insert
|+ Group A
|+ Group B
+- View
|+ Group A
|+ Group B
+- Edit
|+ Group A
|+ Group B
+- Delete
|+ Group B
Olaf