Data Control Language (DCL)

Rumman Ansari   Software Engineer   2023-03-23   6180 Share
☰ Table of Contents

Table of Content:

DCL stands for Data Control Language. It is used to retrieve the stored or saved data. The DCL execution is transactional. It also has rollback parameters.

 

Here are some tasks that come under DCL:

  • Grant: It is used to give user access privileges to a database.
  • Revoke: It is used to take back permissions from the user.

There are the following operations which have the authorization of Revoke:

CONNECT, INSERT, USAGE, EXECUTE, DELETE, UPDATE and SELECT.

‹ Previous -   Data Manipulation Language (DML)
Next › -   Transaction Control Language