SQL> grant resource to ken;
Grant succeeded
SQL> grant resource to ken with admin option;
Grant succeeded
SQL> conn ken
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken
SQL> grant select,insert on test1 to ken2;
Grant succeeded
SQL> grant select,insert on test1 to ken2 with grant option;
Grant succeeded
SQL> conn ken2
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken2
SQL> grant select,insert on ken.test1 to ken3 with grant option;
Grant succeeded
SQL> conn ken3
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken3
SQL> select * from ken.test1;
ID
----------
SQL> conn ken
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken
SQL> revoke select on test1 from ken2;
Revoke succeeded
SQL> conn ken2
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken2
SQL> select * from ken.test1;
select * from ken.test1
ORA-01031: 权限不足
SQL> conn ken3
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken3
SQL> select * from ken.test;
select * from ken.test
ORA-00942: 表或视图不存在
SQL> conn ken
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken
SQL> select * from test;
select * from test
ORA-00942: 表或视图不存在
SQL> select * from test1;
ID
----------
SQL> conn ken3
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as ken3
SQL> select * from ken.test1;
select * from ken.test1
ORA-01031: 权限不足