❌ REVOKE Command in SQL

Last Updated: January 2026

The REVOKE command is a DCL (Data Control Language) command used to remove previously granted permissions from a user or role.

👉 It restricts what operations a user can perform after access was previously given.

  • Cancels SELECT, INSERT, UPDATE, DELETE, or ALL permissions
  • Controls database security
  • Ensures users cannot perform unauthorized actions

Hinglish Tip 🗣: Agar kisi user ka access hataana ho, jo pehle diya tha → REVOKE use hota hai.

Basic REVOKE Syntax

REVOKE permission
ON object_name
FROM user_name;

REVOKE SELECT Permission

REVOKE SELECT ON employees FROM user1;

📌 user1 can no longer read data from employees.

REVOKE Multiple Permissions

REVOKE SELECT, INSERT, UPDATE
ON employees
FROM user1;

📌 All specified permissions are removed.

REVOKE ALL Permissions

REVOKE ALL
ON employees
FROM user1;

📌 Removes all access to the table for user1.

⚠️ Important Points About REVOKE

  • Cannot revoke permissions the user never had
  • Permissions revoked immediately
  • Usually requires admin privileges
  • Works at table-level or database-level

|| राम नाम सत्य है ||

← PreviousNext →