DCL-Revoke

nTo Revoke the permissions for the user to access data

Syntax:

REVOKE CREATE Table, CREATE VIEW from userid

REVOKE INSERT ON Table FROM userid

Query:

REVOKE CREATE Table, CREATE VIEW from Raviteja

REVOKE INSERT ON EMPtbl1 FROM Raviteja