🧠 What is DCL in SQL? #sql #coding #dcl

🔐 Definition
DCL (Data Control Language) is used to control access and privileges in a database.
It ensures that only authorized users can perform specific actions on data or database objects.

🎯 Purpose of DCL
- To protect data from unauthorized access or manipulation.
- To assign roles and permissions to users.
- To maintain database security and integrity by controlling who can read, write, or modify data.

⚙️ Main DCL Commands
| | | | |
| | | GRANT SELECT ON Students TO user1; | |
| | | REVOKE SELECT ON Students FROM user1; | |

Видео 🧠 What is DCL in SQL? #sql #coding #dcl канала Learn with Sap