Database Users

There are 4 categories of database users based on their level of interaction with the database:

• Application Programmers They interact with the system through DML calls

• Sophisticated Users They form requests in a database query language

• Naive Users They invoke a previously written application program to access the data in the database

• Database Administrator (DBA) The database administrator coordinates all the activities of the database system and has a good understanding of the enterprise’s information resources and needs. The DBA has the following duties: ● schema definition ● storage structure and access method definition ● schema and physical organization modification ● granting user authority to access the database ● specifying integrity constraints ● creating stored procedures ● acting as a liaison with users ● monitoring performance and responding to changes in requirements