How enochemerald/hospital-database-system_data-control-language works
Project type and purpose
• This is a database-centric security project that implements Data Control Language (DCL) for a hospital management system.
• Its primary goal is to define user roles, assign table-level privileges, and enforce a Role-Based Access Control (RBAC) strategy for sensitive medical data.
File structure
• Top level:
• Advanced - Data Control Language.sql – the single SQL script that creates roles, users, and grants/revokes permissions.
• README.md – describes the DCL design, user roles, privileges, and security principles.
• No frontend or backend code; all logic lives in the database layer.
README for additional insights
• Four core user roles (Admin, Physician, Nurse, Pharmacist), each mapped to a dedicated database user account.
• Privilege matrix at table level to enforce the principle of least privilege.
• Emphasis on RBAC, user isolation, and granular permissions.