Is there a term that encompasses an authorized, all-privileged DB user and a DB instance with the same name?

Should I call this a DB stack / DB unit / DB packet / something else?

Does this "stack" have a common or formal name that is used among professional database administrators instead of saying: an authorized, all-privileged database user and a database instance with the same name ?

closed as unclear what you're asking by mustaccio, hot2use, Erik Darling, LowlyDBA, RDFozz Jan 22 '18 at 15:36

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    The "root user" is typically the name for the all privileged user. What is a DB instance? Are you referring to a DATABASE, or the server. – Rick James Jan 16 '18 at 0:32
  • By instance I refer to the database of the webapp/webspace, yes. – Arcticooling Jan 16 '18 at 7:36

No, because this isn't a common occurrence or part of any best practice.

The user you're referring to may be called root, sysadmin, sa, or something similar. In many cases these users are disabled or not used frequently to increase system security, though other users with similar privileges most likely exist to take their place.

In most normal cases, naming a database or database server instance the same as the default superuser might be unclear, confusing, and provide no actual information about the data or its use.

Database names may commonly indicate the name of the application it supports, include an indicator of the environment it is in (dev/qa/prod), and/or the type it is (oltp/olap).

For example, some of Microsoft's sample databases for SQL Server are named "AdventureWorks" and "AdventureWorksDW", both named after the fictional company the databases are built around. The second one includes "DW" to indicate it is a data warehouse and not an OLTP database.

  • Deep thanks for the answer, LowlyDBA. I suggest a tiny edit of one word. Please review. Thanks again! – Arcticooling Jan 22 '18 at 0:09

Not the answer you're looking for? Browse other questions tagged or ask your own question.