Database Administration
Write a script that creates:
- At least 2 distinct roles with different sets of permissions (e.g., one with read-only access, another with read-write access)
- At least 2 users, each assigned to one of the roles
Your script should clearly define the permissions granted to each role and demonstrate how users are assigned and managed.
Include comments to explain the rationale behind your permission structure and how it supports the security and integrity of your database.
Scripts should be executable in PostgreSQL. Explicitly include the GRANT/REVOKE statements.
Optionally, you may include DROP statements at the end of your script to clean up users/roles after testing (commented out by default).
Assign different permissions to those roles, e.g., one with read only permissions other with read-write
On top of the code and documentation deliverables, each team member must record a short video (approximately 2 minutes per person) describing the part of the solution they were responsible for. The video should briefly explain your contribution, the challenges you faced, and how you addressed them. The free version of Zoom allows recording of videos during a conference call, making it easy for teams to collaborate and record together. Once recorded, the video can be uploaded to Google Drive or YouTube (as an unlisted video), and the link should be provided as part of the graded material.