Role privilege


Contents

Description

Maps a role to one or more defined privilege(s). Privileges define specific access to data or parts of the system, while roles define higher-level jobs or duties more closely aligned to a person's position — e.g., a privilege may be Create Patient and a role containing that privilege could be Data Manager.

Attributes

Column Name Type Default Description
Primary Key role varchar(50) The role to be assigned a privilege.
Primary Key privilege varchar(50) The privilege assigned to the role — i.e., any users assigned to the role will inherit this privilege.
Primary Key primary key, Required required