Difference between Grant and Revoke

Grant Vs. Revoke: Explore the difference between Grant and Revoke

GRANT & REVOKE are the popular members of the SQL family. These are the types of DCL commands that are used to assign permission to the users to perform a different task. The GRANT command is used for permitting the users whereas the REVOKE command is used for removing the authorization. Let’s find out more differences between GRANT and REVOKE.

What is Grant?

GRANT command is used to give access privileges to the users or other rights or opportunities for the database. This command also allows users to grant permissions to other users too.

What is Revoke?

The REVOKE command does just opposite to the GRANT command. It withdraws user privileges on database objects.

Difference between Grant and Revoke

S.NO

GRANT

REVOKE

1

GRANT command is used to give access privileges to the users or other rights or opportunities for the database.

The REVOKE command does just opposite to the GRANT command. It withdraws user privileges on database objects.

2

It authorizes access preferences to users.

It withdraws access preferences to users.

3

In the GRANT command, you need to define the permissions for each user.

In the REVOKE command, if the access for one user is withdrawn, then all the permissions provided by that particular person to others will also be removed.

4

GRANT is easy to execute.

REVOKE is hard to perform.

Keep learning and stay tuned to get the latest updates on GATE Exam along with GATE Preparation Books & GATE Answer Key and more.

Leave a Comment

Your Mobile number and Email id will not be published.

*

*