Comment: Contains at most one row per user per study, each row defining the PLHDB permission level the study grants to the user. Users are allowed to see only permissions to those studies to which the user has access. HINT: The contents of the underlying PERMISSION table is available in an unfiltered form to PLHDB manager accounts. HINT: See also the ACCOUNTS and ACCESS_GROUPS views.
|pid||integer NULL||Unique row identifier. The value of this column is automatically assigned by the system; the normal practice, which results in a system generated id, is to omit this column when inserting new rows or to supply a NULL value. The value of this column cannot be NULL.|
|username||name NULL||The ROLE.rolname of the user to which permission is granted. The value of this column cannot be changed. HINT: See the "accounts" view for information on users.|
|study||character varying(12) NULL||The STUDY.Name of the study to which permission is granted or 'all' if permission is granted to all studies.|
|access||character varying(10) NULL||The type of access granted. Must be one of: search = Can read study data; insert = search permissions + Can create new rows; edit = insert permissions + Can alter existing rows; all = edit permissions + Can delete existing rows.|