Role Based Access Control (RBAC) is where a user belongs to one or several roles. There are then permissions assigned to a specific role; they allow or deny user access to subjects.

In this recipe, we're going to use a simplified approach, where users will belong to exactly one role, and permissions will be set to allow access to controller actions. By default, all actions will be denied, and we'll configure which roles can access which actions in our application. For this, we'll use a custom authenticate class and a configuration file to define the permissions. Easy to maintain and human readable.

CREATE TABLE users (
  id VARCHAR(36) NOT NULL,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(128) NOT NULL,
  active TINYINT(1) DEFAULT '0',
  created DATETIME DEFAULT NULL,
  modified DATETIME DEFAULT NULL,
  PRIMARY KEY(id)
);