SQL GRANT command is used to grant access or privileges on the database objects to the users.
SYNTAX

Where,
-
privilege_name : is the privilege GRANTED to the user
-
object_name : is the name of the database object like table, view etc.,
-
user_name : is the name of the user to whom an access right is being GRANTED. Public is used to grant rights to all the users.
SQL REVOKE Command removes user access rights or privileges to the database objects.
SYNTAX

Where,
-
privilege_name : is the privilege REVOKED from the user
-
object_name : is the name of the database object like table, view etc.,
-
user_name : is the name of the user from whom an access right is being REVOKED.
Want More SQL Deep Dives