Explain the different types of users who play different roles in DBMS?

There are a number of users who can access or retrieve the data on demand using the application and the interfaces provided by the Database Management System (DBMS).

Types of Users

The users of the database can be classified into the following groups −

Native users − The native users need not be aware of the presence of the database system. They are end users of the database who works through a menu driven application programs, where the type and range of response is always indicated to the user

Online users − Online users may communicate with databases directly through an online terminal or indirectly through user interface and application programs.

Sophisticated Users − They are those users who interact with the system without writing the program instead they form their request in database query language. They are the SQL programmers, who are going to deal directly with the database. They write queries to delete or select or insert and update the database.

Specialized Users − Specialized users who write specialized database applications that do not fit into the fractional database processing framework.

Application Programmer − The application programmer users who are responsible for developing the application programs or user interface. The application programs could be written in high level language. For example − Java, .net, php etc,

Database Administrator (DBA) − It is a person or the group in charge of implementing the database system within the organization. The DBA has all the privileges allowed by the DBMS and can assign or remove the privileges from the users.

Classification of Users

DBMS mainly classified into three users −

  • End Users.

  • Application Programmers.

  • Database Administrator.

The classification of users in DBMS is pictorially represented below −