Description

Assigns a user to one or more roles within the system. Users are given privileges within the system through role assignment. For example, Mary might be given the roles Nurse and Researcher. Her Nurse role could grant her the privilege to write orders within the system while her Researcher role may include privileges to allow her to access data summary pages otherwise inaccessible to nurses. The use of roles allows administrators to more easily manage privilege assignment, rather than forcing them to individually assign dozens of privileges for each user — e.g., while the Nurse and Researcher roles may each contain a dozen specific privileges, the administrator needs only to assign two roles to Mary. Additionally, if a new privilege is granted to the Nurse role in the future, Mary will automatically inherit that privilege.

Attributes

	Column Name	Type	Default	Description
	user_id	int		User who is being assigned to a role.
	role	varchar(50)		The role assigned to the user.
primary key, required