Role-Based Access Control (RBAC) is a security model that assigns system permissions according to a user's job role rather than assigning permissions individually.
For a web application using PHP, MariaDB, Bootstrap 5, and JavaScript, RBAC provides a structured way to control access.
1. Common user roles
Role | Access |
|---|
Super Administrator | Complete system access |
Administrator | Manage users, roles, and settings |
Manager | Manage employees and operational records |
Supervisor | Review and approve transactions |
Employee | Access assigned functions |
Read Only | View records without modifying them |
2. RBAC architecture
3. Suggested MariaDB database tables
users – User accounts.
roles – Defined system roles.
permissions – Available permissions.
user_roles – Assigns roles to users.
role_permissions – Assigns permissions to roles.
audit_log – Records security-related activities.
4. Permission examples
Module | Permission |
|---|
Users | users.create |
Users | users.read |
Users | users.update |
Users | users.delete |
Employees | employees.manage |
Payroll | payroll.approve |
Reports | reports.view |
Settings | settings.manage |
Important: Enforce permissions on the server side, not just by hiding buttons in Bootstrap.
5. What would you like to build?
Technology stack
PHP 8.4 + MariaDB + Bootstrap 5
Yii2 + MariaDB + Bootstrap 5
Implementation
Complete RBAC system with CRUD
Authentication and authorization engine
Integrate into an existing application
Include these features
User management
Role management
Permission management
Audit logging
Department-level access
Multi-factor authentication