将一个用户下所有表的查询权限赋给另一个用户

将一个用户下所有表的查询权限赋给另一个用户


set pagesize 9999;
set heading off;
spool /tmp/run_grant.sql


SQL> select 'grant select on '||owner||'.'||object_name|| ' to user1;'
  2  from dba_objects
  3  where object_type='TABLE'  and owner='SCOTT';


'GRANTSELECTON'||OWNER||'.'||OBJECT_NAME||'TOUSER1;'
------------------------------------------------------------------------------
grant select on SCOTT.BONUS to user1;
grant select on SCOTT.CC to user1;
grant select on SCOTT.CC1 to user1;
grant select on SCOTT.DEPT to user1;
grant select on SCOTT.EMP to user1;
grant select on SCOTT.SALGRADE to user1;
grant select on SCOTT.T1 to user1;
grant select on SCOTT.T2 to user1;
grant select on SCOTT.TT to user1;
已选择9行。


spool off;


@/tmp/run_grant.sql




查看对象的权限：dba_tab_privs


vi 编辑器
到最后一行：大写G 或者 esc:$
向下翻页：ctrl+f
向上翻页：ctrl+b