🎁 GRANT Command in SQL

Last Updated: January 2026

The GRANT command is a DCL (Data Control Language) command used to give permissions to database users or roles.

👉 It controls what operations a user is allowed to perform.

Using GRANT, you can allow users to:

  • Read data
  • Insert data
  • Update data
  • Delete data
  • Access entire database objects

Hinglish Tip 🗣: Kisi user ko database ka right dena ho, jaise read ya write access — tab GRANT use hota hai.

Basic GRANT Syntax

GRANT permission
ON object_name
TO user_name;

GRANT SELECT Permission

GRANT SELECT ON employees TO user1;

📌 user1 can:

  • Read data from employees
  • Cannot insert, update, or delete

GRANT Multiple Permissions

GRANT SELECT, INSERT, UPDATE
ON employees
TO user1;

GRANT ALL Permissions

GRANT ALL
ON employees
TO user1;

📌 Gives full access to the table.

Show User Privileges

SHOW GRANTS ;

-- OR
SHOW GRANTS FOR user_name;

⚠️ Important Points About GRANT

  • Requires admin or owner privileges
  • Permissions can be table-level or database-level
  • Granted rights remain until revoked
  • Syntax may vary across databases
← PreviousNext →