The following tables form the base of the OpenACS permission system.
Table
Cols
Rows
Description
[acs_permissions]
3
1870
List of explicitely granted permissions.
[acs_privilege_descendant_map]
2
487
Denormalized index of privilege parent/child relationship. Created by a trigger to speedup permission checks.
[acs_privilege_hierarchy]
2
193
The acs_privilege_hierarchy gives us an easy way to say: The foo privilege is a superset of the bar privilege.
[acs_privilege_hierarchy_index]
3
368
Denormalized index of privilege parent/child relationship. Created by a trigger to speedup permission checks.
[acs_privileges]
3
183
Privileges share a global namespace. This is to avoid a situation where granting the foo privilege on one type of object can have an entirely different meaning than granting the foo privilege on another type of object.