View: permissions

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.

ColumnTypeComment
pidinteger NULLUnique 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.
usernamename NULLThe 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.
studycharacter varying(12) NULLThe STUDY.Name of the study to which permission is granted or 'all' if permission is granted to all studies.
accesscharacter varying(10) NULLThe 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.
Language: