SQL GRANT REVOKE COMMANDS

GRANT | REVOKE

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.