Test field level permissions

[fyliu]

Overview

We are planning on including field-level security for tables. The required permissions need to be tested before implementation.

Action Items

• implement code needed for FLS (tables, possibly models)
  • create tables
  • add test data
• test Practice Lead project
• create test cases for FLS

Resources/Instructions

• PostgreSQL documentation for field-level security policies
• Django multitenancy
• Use cases and tests for FLS feasibility: Discuss our requirements for permissions hackforla/peopledepot#150 (comment)
• Tables and test data
• Ethan's proposal and documentation on the wiki: https://github.com/hackforla/peopledepot/wiki/Security:-Field-Level-Proposal-(using-Github-Copilot)