thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

REVOKE Statement

The DCL statement that removes previously granted privileges from a user or role.

Definition

REVOKE undoes a GRANT. With CASCADE, it also removes privileges the grantee passed on through WITH GRANT OPTION. Revoking from a role affects every user who holds that role.

Example

REVOKE INSERT ON Sales.Orders FROM AnalystRole;

Exam tip

REVOKE removes a grant; SQL Server's DENY explicitly blocks a permission even if it is granted through another role.

Related terms