To create a user and database, we need to execute the following through the main role:

create user {user} with login password '{password}' role {master_user};
create database {database} with owner {user};
revoke {user} from {master_user};

To remove you need to do this:

grant {user} to {master_user};
drop database {database};
drop role {user};