Need Of DCL commands
- Unauthorized access to the data should be prevented in order to achieve security in our database
- DCL commands maintain the database effectively than anyone else other than database administrator is not allowed to access the data without permission.
- These commands provide flexibility to the data administrator to set and remove database permissions in granular fashion.
DCL Full Form
The full form of DCL is Data Control Language in Structured Query Language (SQL). DCL commands are used to control privileges in the database. The privileges (right to access the data) are required for performing all the database operations, like creating tables, views, or sequences. DCL statements are used to perform the work related to the rights, permissions, and other control of the database system.
There are two types of privileges in the database:
- System Privilege
- Object Privilege
Table of Content
- Need Of DCL commands
- Commands in DCL
- GRANT
- REVOKE
- Advantages Of DCL commands