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;

Revoke

For Online Classes Contact Us: +919885348743

For
Online Classes

Contact Us: +919885348743