What is the purpose of DCL Language?

0

DCL (Data Control Language) allows users to control access and permission management to the database. It is the subset of a database, which decides what part of the database should be accessed by which user at what point of time. It includes two commands, GRANT and REVOKE.

  • GRANT: It enables system administrators to assign privileges and roles to specific user accounts to perform specific tasks on the database.
  • REVOKE: It enables system administrators to revoke privileges and roles from the user accounts so that they cannot use the previously assigned permission on the database.

Example
GRANT * ON mydb.Student TO mail@localhsot;

Sql
asked Apr 14, 2023 at 21:39
Sign in to add a comment

0 Answers

0
📝 No answers yet!

Be the first to answer this interview question.

Your Answer

Sign in to post your answer and help the community.