I was setting up a permissions structure in the bank (GRANT, REVOKE), when I found this article and found it interesting to share, even to have here in SOpt.
Original issue
- What is DCL?
I was setting up a permissions structure in the bank (GRANT, REVOKE), when I found this article and found it interesting to share, even to have here in SOpt.
Think like this, the SQL language is one, but it is divided into types according to the functionality of the commands. The SQL language types are:
DDL - Data Definition Language - Data Definition Language.
They are the commands that interact with the objects of the bank.
DML - Data Manipulation Language - Data Manipulation Language
They are the commands that interact with the data within the tables.
DQL - Data Query Language - Data Query Language.
These are the query commands.
DTL - Data Transaction Language - Data Transaction Language. These are the commands for transaction control.
DCL - Data Control Language - Data Control Language.
These are the commands to control the security part of the database.
Luiz Fernando
Fonte