Oracle Revoke - oracle tutorial - sql tutorial
What is Oracle REVOKE ?
- The Oracle REVOKE statement is used to retrieve the given permissions or privileges on tables from the other users.
Syntax:
REVOKE SELECT, UPDATE, INSERT ON table_name FROM user_name;
click below button to copy the code. By - oracle tutorial - team
Example:
- I’m try to revoke the SELECT and UPDATE privileges on wikitechy_dtl(table) from other user (‘Dharma’).

- By using REVOKE Privilege we can able to retrieve the privileges (insert ,update, etc..) on particular column also.
Example:
REVOKE UPDATE (emp_name), INSERT (emp_id, ename) ON wikitechy_dtl FROM Arun
click below button to copy the code. By - oracle tutorial - team
Explanation:
- The user cannot take back column level privileges. Suppose the user just want to take back insert privilege on emp_name column then the user have to first take back the whole insert privilege and then grant privilege on emp_id and ename column.