Select data Show structure Alter table New item
Comment: Contains at most one row per user per study, each row defining the
PLHDB permission level the study grants to the user. PLHDB
permissions apply only to PLHDB manager and user accounts, and
managers may change any of them. When a user has no row for a study
the user has no permissions to the study. The combination of study
and username must be unique. When study is 'all' the
username must be unique.
Adding a row to PERMISSION can only increase a user's access.
Permission is never taken away. So, in case of conflict between
permission granted to all studies and permission granted to a specific
study the user has the more permissive of the two.
TIP: The contents of this table is accessible only to administrator
and PLHDB manager accounts; use the PERMISSIONS view instead.
Add foreign key