grammatical number - Correct way of saying I want a list of the names of each individual entity in a group?

I'm a programmer and in a program I'm currently creating, I want to get a list of all the accounts names that can access a database.

I have no idea if I'm supposed to "get account names", to "get accounts name" or to "get accounts names".

My best guess is that "get accounts names" is the correct answer as it seems more logical to say it that way, but I see the first case used the most, which makes me doubt about this.

The way I see it, "get account names" would refer to multiple names given to a single account and "get accounts name" would be the name of the group of accounts, but I'd like some clarification on this.

Answer

This depends mainly on whether you wish to emphasize "account" and "name" as being a single unit (an "account name") or as separate units (the "name" of an "account").

In the first case, an "account name" is a single thing. So you can think of it as being a parenthesized term, and then pluralize thus: "(account name)s". You can see that "account" is not pluralized, since an "accounts name" is not a thing.

However, if you wished to separate "account" and "name" as concepts, you would say "Get accounts' names", where the apostrophe indicates that names belong to accounts.

In normal English usage, I have seen the "Get account names" formation much more often.