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

Copy Code

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

Copy Code

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.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning