Data Control Language (DCL) commands:

Data Control Language (DCL) commands:

Data Control language is used to control privilege, create roles and permissions in Database.

To perform any operation in the database,such as creating tables,views or sequences we need privileges.

        GRANT - gives users access privileges to database
        REVOKE - withdraw access privileges given with the GRANT command 

Privileges are two types:
1).System Privileges                                                                                             

The system privilege means enables users to perform particular actions in the database. We will use DDL command in the system privilege and this privilege is effect on the system.      

Example: Create table, sysdba, Create view etc.          
    

2).Object Privileges               

The object privilege means enables users to access and manipulate a specific object. We will use DML command in the system privilege and this privilege is effect on the parameter object.      

Example: Alter Command, Select Command, Delete Command etc.