Download the BYJU'S Exam Prep App for free GATE/ESE preparation videos & tests - Download the BYJU'S Exam Prep App for free GATE/ESE preparation videos & tests -

DCL Full Form

What Is The Full Form Of DCL?

The Full Form Of DCL is a Data Control Language

DCL commands are used to control the access data stored in a database. To execute any operation related to a database such as creating the table, managing the data, we require permission. And, here comes the use of the DCL command. This command is used to perform all these tasks and helps in controlling the database system.

Commands in DCL

There are two important commands in DCL: Grant and Revoke

Grant: As the name suggests, this command is used to grant consent to the user to execute a particular operation. The GRANT command is used to add new permissions to a database user. The syntax for this command is:

GRANT privilege_list

ON Object_name

TO user_name;

Revoke: The REVOKE command is used to eliminate database access from a user. The syntax for REVOKE command is:

REVOKE privilege_list

ON object_name

FROM user_name;

Need of DCL commands

  • To achieve security and prevent the database from unauthorized access, the DCL is required.
  • DCL commands help in maintaining the database. Even an administrator can not access it without permission.
  • DCL commands grant full support and flexibility to the administrator to sustain the database.

Advantages of DCL

  • DCL has the ability to ensure security when the data is disclosed to various users.
  • DCL is fully protected. It restricts unlawful and unofficial users from reaching the database.
  • Date administrators can use the GRANT and REVOKE to prevent the data from any damage.

Comments

Leave a Comment

Your Mobile number and Email id will not be published.

*

*