Please enable JavaScript.

Coggle requires JavaScript to display documents.

Data security (Types of Security and Threats to Database Systems (Types…

- - - - Granting and Revoking Privileges
        –Specify privileges for users on database objects
        -Remove privileges from users on database objects.
      - Discretionary Privileges
        
        Object Privileges
        
        System Privileges
      - Propagation of Privileges
        Whenever the owner a of a relation R grants a privilege on R to another account B, the privilege can be given to B with or without the grant option
      - The account level:
        At this level,the DBA specifies the particular privileges that each account holds independently of the relations in the database
      - The relation (or table) Level
        At this level, the DBA can control the privilege to access each individual relation or view in the database