把用户oaks所有表的权限授予另一用户oak

把某一用户所有表的权限授予其它用户

1、创建相应的用户，并授予必要权限           

create user oak identified by oak;

create user oaks identified by oaks;

grant create session to oaks;

grant create session to oak;

alter user oaks quota 50M on users ;

alter user oak quota 50M on users;ITPUB个人空间:F g2A^.M2K&s
2、创建测试用表

create table oaks.oaksITPUB个人空间{[Z4zw3q
(id number);ITPUB个人空间 R aA1? z3t3kH
create table oaks.testITPUB个人空间/P3Z0O)nMm%ZyB
(id number);
f sX2eE s0insert into oaks.oaks values (7);

insert into oaks.test values (9);
.nV@+n/_rjy0commit

3、授权

3.1在sqlplus 下运行下面的语句

spool /tmp/grant_oak.sql

select 'grant all on oaks.'||table_name||' to oak;' from dba_tables where wner='OAKS';
AG,fk/mD0select 'create synonym oak.'||table_name||' for oaks.'||table_name||';' from dba_tables where wner='OAKS';
3Sqb`?0spool off

3.2退出sqlplus编辑把grant_oak.sql的非授权语句删掉

3.3运行grant_oak.sql

sqlplus / as sysdba
X'i-{J,n0

@/tmp/grant_oak.sql
O(z'Uoy7D)@,F0

4、以oak连接测试

select * from test;