Revoke

REVOKING PRIVILEGES
            Privileges once given can be denied to a user using the REVOKE command. The object owner can revoke privileges granted to another user. A user of an object who is not the owner, but has been granted the GRANT privileges, has the power to REVOKE the privileges from a grantee.
Syntax:- REVOKE object privileges ON object name FROM user name;
Ex:-     1) revoke all on vision from vision;
            2) revoke select on vision1 from vision;
            3) revoke select on vision2 from vision;
            4) revoke select,update on vision3  from vision;

Vision User

•  select * from scott.vision;
• select * from scott.vision1;
• select * from scott.vision2;
• update scott.vision2 set sal=sal+100;
• select * from scott.vision3;
• update scott.vision3 set sal=sal+100;

Select * from scott.vision3;

 

 

For
More Explanation
&
Online Classes

Contact Us:
+919885348743