Database users are the people or programs that use a database for different purposes. Some users access the database directly by writing and executing queries. Others use the database indirectly through an application or software program. Different users interact with the database in different ways depending on their roles and responsibilities. Some users may only view or search for data, while others may add, update, or delete data. The way a person uses a database also depends on their knowledge of computers and databases. For example, a DBA needs advanced database knowledge, while an end user may only need basic knowledge. Therefore, database users can have different levels of access and responsibilities based on their needs.
Types of Database Users
- Naive (End) Users
These people just use a ready-made form or screen. They click buttons and fill fields. They don’t know SQL. They don’t know how the database works inside.
Example: A bank clerk who deposits money using a simple screen. - Application Programmers
These are developers. They write the programs (using Java, Python, C++, etc., along with SQL) that connect to the database. Normal users then use these programs. - Sophisticated Users
These users know SQL. They write their own queries to get exactly what they want. They don’t need any app they talk to the database directly.
Example: Data analysts, engineers, scientists. - Specialized Users
These users build special, non-traditional database applications. Examples: CAD (design) software, expert systems (AI knowledge-based systems), and systems that store audio, video, or graphics data. - Database Administrator (DBA)
This is the main person in charge of the whole database. The DBA controls who can access the data, keeps it secure, backs it up, and makes sure it runs smoothly. - Casual Users
These users open the database only sometimes, not daily. Each time, they need different information, and they use a query language to get it.
Example: A manager checking sales figures once a month