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.
ExampleGRANT * ON mydb.Student TO mail@localhsot;
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.