During database operations, developers create various users to perform database operations. This topic aims to help developers standardize user naming in the database. The naming conventions mentioned here are suggestions for reference.
This topic describes user naming conventions by user function. Different businesses can apply different conventions based on their scenarios. This topic serves as an example only. Non-system users in the database can be categorized by function as follows: business object owners, application users for database access, tool users, monitoring users, data backup users, database management users, and general test users. The naming conventions for each type are as follows.
Business object owners
A business object owner is responsible for creating and maintaining objects in the database. To name a user of this type, use the format of "subsystem abbreviation + data". For example, you can name an owner of the abs subsystem as "absdata".
Application users for database access
Application users for database access are primarily responsible for connecting to the database and operating on business data. To name a user of this type, use the format of "subsystem abbreviation + opr". For example, you can name an application user of the abs subsystem as "absopr".
Tool users
Many users in the database use specific tools, such as those for data migration. To name these users, consider using the tool name as a basis. For example:
To name a kettle user, use the format of "subsystem abbreviation + ktl". For example, you can name a kettle user of the abs subsystem as "absktl".
To name a sqoop user, use the format of "subsystem abbreviation + sqp". For example, you can name a sqoop user of the abs subsystem as "abssqp".
Monitoring users
You can create an independent user for monitoring purposes in the database. The recommended name for users of this type is "dbmonopr".
Data backup users
You can create users for backup purposes in the database. To name a user of this type, use the format of "subsystem abbreviation + bak". For example, you can name a backup user of the abs subsystem as "absbak".
Database management users
A database management user is a database administrator (DBA) who manages the database. You can name the user "dbmgr". To distinguish between a production database and a test database, you can name the DBA user in the test database "testmgr".
General test users
You can create a user with high privileges on database operations for test purpose. To name a user of this type, use the format of "subsystem abbreviation + test". For example, you can name a test user of the abs subsystem as "abstest".