Methods {row-level security} can control access to project data based on role assigned to a user by the administrator, because projects and roles are linked. The table privileges granted to a role are removed. A package has a function to make the predicate for the queries. Policies use the predicate-creating function on all statements (SELECT, INSERT, UPDATE, DELETE) on the project tables. Depending on the role assigned to the user and the projects paired with that role, users logging in will only see the protocols or experiments associated with the allowed projects.
Mathematical Sciences>Computer Science>Software>Security
3-Computer Science-Software-Security
Outline of Knowledge Database Home Page
Description of Outline of Knowledge Database
Date Modified: 2022.0224