What word would you pick instead of "USER" for users in the context of DBMS ?

SPBS · on Oct 12, 2023

I just name it users and accept the minor inconsistency that every table is singular except for the users table (it has the lowest cognitive overhead IMO)

reportgunner · on Oct 12, 2023

No, I mean the word USER in a statement like below

  CREATE USER user_name   
    [
      { FOR | FROM } LOGIN login_name   
    ]  
  [ WITH <limited_options_list> [ ,... ] ]   
  [ ; ]

yencabulator · on Oct 13, 2023

It's a shame that the classic style separation of lexing and parsing means to support the command CREATE USER FOR LOGIN WITH means all of those are now magic keywords, instead of only behaving so in the context of a CREATE command.

As for how to name the "user" table, I've used "account". User is a human not a piece of data, Account is the data I have about their association with my service.