When we setup the new projects/functional groups In traditional infra we used to follow a heirarchy of roles as per the organization. When the IT systems access is required the sysadmin/infra team used to follow the similar setup.
When we come to AWS Cloud setup, we need to follow the similar setup, which is called Identity Access Management [IAM].
The following video has the detailed discussion on IAM usage and its function.
How to do MySql-Server setup on AWS EC2 with a table/data creation/deletion ?
If you are a DBA and want to use EC2 VM for MySql-virtual server, this might be the right Exercise/video to look into it as POC for client interviews also.
Even if you are a developer or test engineer or devops engineer; need to create such environment for some of the tasks like; a) Dev environment, b) Test environment, c) During deployment you need to create this kind of environment – if you need to do manually without an IAC code.