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