MSK Institute • Shikohabad
Loading Page Content...
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Connecting serverPlease wait...
💻 Practical Labs🚀 Free Demo📜 Verified Certificates
Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...
Creating a user account is only the first step. By default, a newly created MySQL user has zero privileges and cannot even view or query user databases.
The GRANT statement assigns specific operational permissions to user accounts at granular levels: Global, Database, Table, or Column.
MySQL's privilege hierarchy operates on four distinct scopes:
SUPER, RELOAD, SHUTDOWN).):** Privileges apply to all tables within a specific database (e.g., SELECT, INSERT, CREATE, DROP`).db_name.table_name): Privileges apply strictly to a single designated table.SELECT (col1, col2) ON db.table): Privileges apply strictly to specified columns within a table.Backend application servers usually require CRUD operations on tables, but should never have permissions to drop tables or databases:
Suppose an external contractor needs to update inventory prices, but should not see cost margins:
Appending WITH GRANT OPTION allows the recipient user to grant their own assigned privileges to other users!
WITH GRANT OPTION to regular application users. Reserve it exclusively for database administrators.To check the exact permissions granted to an account:
Continue learning with hands-on practice, examples, and exercises in the upcoming topic.
| Previous Lesson | Next Lesson |
|---|---|
| Creating & Managing MySQL Users | Revoking Privileges & FLUSH PRIVILEGES |
Test your understanding of this lesson with 5 questions. Each question has one correct answer.