Skip to main content

Posts

Showing posts with the label The Crazy Programmer Different Types of Database Users Different Types of Database Users The Crazy Programmer

Different Types of Database Users Jitendra Ajmera The Crazy Programmer

According to tasks performed on the database by different users, we can classify database users in 5 categories as given below: Database Administrator Naive Users Application Programmers Sophisticated Users Specialized Users Let’s discuss each one by one in detail. 1. Database Administrator (Super Users) A single person or a team of members can be a database administrator. An administrator has full control of the database. Their account is called a superuser account. An administrator defines the logical and physical schemas and manages all three levels of the database. Even they can control view level schemas as well. They grant/revoke authorization permission to all other users. They design the overall structure of the database including, layouts, functioning, procedures, and motives. They are responsible for routine maintenance, backup, and recovery of the database. They perform all admin related activities like time to time updating, insert new required values /funct