GRANT Commands in SQL | User Permissions in MySQL with DCL | MySQL Pashto Course Lecture 20
Learn how to grant SELECT, INSERT, and more privileges to users in MySQL using SQL GRANT command.
Welcome to Lecture 20 of the MySQL Full Course in Pashto, taught by Malik Ahad on the IT HUB channel.
In this lecture, we focus on the GRANT command in SQL — a powerful Data Control Language (DCL) feature used to assign user permissions in MySQL databases. Whether you're managing a school database or working with live SQL environments, this video teaches you how to safely grant access to users using practical examples — all in Pashto language.
🔍 What You’ll Learn in This Video:
1. Introduction to Data Control Language (DCL).
2. Purpose and use of the GRANT command.
3. GRANT syntax explained step-by-step.
4. Giving permissions like SELECT, INSERT using SQL.
5. Real-world project example: SchoolManagementSystem database.
6. Granting access to specific tables (e.g., Students table).
7. Understanding 'username'@'host' structure.
8. Best practices for user access control in MySQL.
9. Live demonstration using SQL query and MySQL interface.
10. Why permission management is important in database security.
🔔 Subscribe to IT HUB to continue this free MySQL Course in Pashto.
🎓 Also available: CCNA, Java, Cybersecurity, MS Office, and more – in Pashto!
📱 Follow Us:
👍 Facebook Page Link: / ithubfbpage
📱 What'sApp Group Link: https://chat.whatsapp.com/IFilHCvlUaA...
📑 Download Notes (Telegram): https://t.me/ithubpashto
Must-Watch Videos:
► • User Creation Manually & with Code | DCL i...
► • MySQL School Management System Project SOL...
MySQL Complete Course:
► • Introduction to SQL, Database & DBMS in Pa...
Java Complete Course:
► • Introduction to Java & JDK Installation | ...
CCNA Complete Course
► • Introduction to CCNA: Complete Course in P...
Photoshop Pashto Complete Course:
► • Adobe Photoshop Pashto Beginners Course: I...
Let’s unlock the world of tech together—subscribe now! 🚀