How Can You Define The Authorization Control In Centralized Database Environment?

The authorization control in a centralized database management system consists of the three components as:
1. object
2. user
3. operations

The user is that who use the application and perform the operations defined by that application. The objects are database components on which those operations are performed.

The authorization control checks and determines which users are allowed to perform which operations on which type of objects. Thus in the case of a centralized database environment the authorization constraints can be properly specified by defining the users, objects and access rights.

The user is identified by a used name and a password. The user name uniquely identifies a user in the system while the password is only known by that user. The users are authenticated by providing this pair (the user name and password) to the system.
The objects are actually the database subsets. In the context of relational database these objects may be defined either by type (like rows, columns, views etc) or by their contents.
A right actually determines a relationship between a user and an object to perform a particular set of operations. These rights can be assigned or revoked  in SQL by using the following general syntax:GRANT ON