[Bug]: Permission System Architecture Needs Redesign for Fine-Grained Access Control

[asterixix]

Describe the bug
The current permission system is too simplistic and doesn't support the fine-grained access control needed for complex organizational structures. It has a flat permission model that can't accommodate hierarchical inheritance or context-sensitive permissions required for the Advanced Association Management MVP.

Steps to Reproduce

1. Attempt to create a permission that applies only to a specific organizational unit
2. Try to define roles with graduated permissions across resource types
3. Attempt to inherit permissions from a parent organization to a child
4. Observe that the current permission system doesn't support these scenarios

Expected behavior
The permission system should support hierarchical roles, fine-grained access controls, and context-sensitive permissions that can be applied at different levels of the organization hierarchy.

Screenshots
N/A - Architecture issue

Desktop (please complete the following information):

• N/A - System-wide architecture issue

Additional context
This architectural limitation requires addressing early in the MVP development to ensure proper security and access control. The redesigned permission system should:

• Support hierarchical inheritance of permissions
• Allow context-sensitive permissions (e.g., by resource type, category)
• Enable temporary permission assignments
• Provide efficient permission checking without performance bottlenecks
• Maintain comprehensive audit logs of permission changes