SQL REVOKE Command Explanation with example

Prabhukiran345
Posted by Prabhukiran345 under Sql Server category on | Points: 40 | Views : 1027
SQL REVOKE Command:The REVOKE command removes user access rights or privileges to the database objects.
Syntax:
REVOKE privilege_name 
ON object_name
FROM {user_name |PUBLIC |role_name}

Example:
REVOKE SELECT ON employee FROM user1

This command will REVOKE a SELECT privilege on employee table from user1.

Comments or Responses

Login to post response