| Database Installation and Setup |
P1: Install a relational database management system. Verify the database service is running and accessible from localhost. Create and import databases and tables |
|
|
| Database User Management |
P2: Create database-specific users and assign privileges using least privilege principles |
|
|
| Database Security |
P3: Enforce password usage. Disable default accounts and allow remote connections. Remove unnecessary default users and databases |
M1: Enforce strong password algorithms |
|
| Database Backup and Recovery |
|
M2: Create a manual backup of the database and restore the backup |
|
| Database Monitoring and Logging |
|
M3: Enable monitoring and logging |
|
| Database Hardening |
P4: Restrict user logins |
|
D1: Restrict database access by IP address or subnet. |
| Troubleshooting |
|
M4: Debug database service errors. |
|
| Verbal Pass off |
P5: Successfully answer two TA chosen pass off questions. |
|
|