将一个用户下所有表的查询权限赋给另一个用户
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