PostgreSQL

The receptionists at Dunder Mifflin would like to create and manage their own database of visitors to the office. Create two roles, erin and erin_admin. Make the erin_admin role a superuser. Create a database named visitors with erin_admin as the owner.

psql postgres

postgres=# CREATE ROLE erin;
postgres=# CREATE ROLE erin_admin WITH SUPERUSER;
postgres=# CREATE DATABASE visitors;
postgres=# ALTER DATABASE visitors OWNER TO erin_admin;
postgres=# \q

psql visitors
visitors=# \du
                                    List of roles
 Role name  |                         Attributes                         | Member of 
------------+------------------------------------------------------------+-----------
 erin       | Cannot login                                               | {}
 erin_admin | Superuser, Cannot login                                    | {}
 postgres   | Superuser                                                  | {}
 secilreel  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}