Oracle Object Permissions

Drop user test cascade;
Create user test identified by test;
Grant create session to test;
Grant create any table to test;
Conn Test/test;
CREATE TABLE Scott.test (ID number);
Conn Scott/tiger;
INSERT INTO Test values (888);
SELECT * from Test;
Conn Test/test;
SELECT * from Scott.test;
Conn Scott/tiger;
Grant Select on test to test;
Conn Test/test;
SELECT * from Scott.test;
Conn Scott/tiger;
ALTER TABLE test Add (name varchar (10));
SELECT * from Test;
Granting update permissions can be added more carefully to a column
Grant update (name) on test to test;
Conn Test/test;
Update scott.test Set name = ' John Doe ';
Update scott.test Set id = ' 999 ';

Conn Sys as SYSDBA;

Create user test1 identified by Test1;
Create user test2 identified by Test2;
Grant create session to Test1, Test2;
The following options indicate that you can cascade authorization
Grant SELECT on Scott.emp to test1 with GRANT option;
Conn Test1/test1;
Grant SELECT on Scott.emp to Test2;
Conn Test2/test2;
SELECT * from Scott.emp;
Conn Sys as SYSDBA;
Revoke select on Scott.emp from Test1;
Conn Test2/test2;
SELECT * from Scott.emp; I can't find it.

Oracle Object Permissions