GRANT and REVOKE command in SQL

The difference between the GRANT and REVOKE command is as under:

SQL GRANT Command

SQL GRANT is a command used to provide access or privileges on the database objects to the users. The Syntax for the GRANT command is:

GRANT privilege_name

ON object_name

TO {user_name |PUBLIC |role_name}

[WITH GRANT OPTION];

SQL REVOKE Command:

The REVOKE command removes user access rights or privileges to the database objects.The Syntax for the REVOKE command is:

REVOKE privilege_name

ON object_name

FROM {user_name |PUBLIC |role_name}

privilege_name is the access right or privilege granted to the user. Some of the access rights are ALL, EXECUTE, and SELECT.

object_name is the name of an database object like TABLE, VIEW, STORED PROC and SEQUENCE.

user_name is the name of the user to whom an access right is being granted.

PUBLIC is used to grant access rights to all users.

role are a set of privileges grouped together.

WITH GRANT OPTION- allows a user to grant access rights to other users