Populate security privileges for roles

[ethanstrominger]

Blockers/Dependencies

None

Overview

REPLACE THIS TEXT -Text here that clearly states the purpose of this issue in 2 sentences or less.

Action Items

• Create script that will:
  • If PEOPLE_DEPOt_SYNCH=TRUE
    • kb.admin: all privileges for kb,view privileges for PD. For V2, allow update of users
    • kb.maintainer: all privileges for kb, view privileges for pd
    • kb.approver: same as maintainer
    • kb.view: all view privileges for kb and pd
  • If PEOPLE_DEPOT_SYNCH=FALSE
    • kb.admin: all privileges for all tables
    • kb.maintainer: all privileges for all tables except view only for users
    • kb.approver: same as maintainer
    • kb.view: all view privileges for kb and pd

How to Manually Verify

REPLACE THIS TEXT - Describe how to manually verify either through UI or executing the code and inspecting.

Automated Tests

Any automated tests?

Resources/Instructions

REPLACE THIS TEXT -If there is a website which has documentation that helps with this issue provide the link(s) here.