Do we need a separate database account for each artist?

For a small studio, no — one shared account is the simplest, most reliable setup, and a database server is built to handle many connections under one login.
What actually matters is that the account has full privileges (Section 4).
Studios with stricter security policy can use per-user accounts; see the advanced note in Section 4.