将某个用户的所有表的查询权限授权给另一个用户

详细操作步骤：

1.检验当前用户

SQL> show user;
USER is "SCOTT"

2.查询当前用户的所有表

SQL> select table_name from user_tables;

TABLE_NAME
------------------------------
DEPT
EMP
BONUS
SALGRADE

3.拼接查询语句

SQL> select 'grant select on ' || table_name || ' to test051;' from user_tables;

'GRANTSELECTON'||TABLE_NAME||'TOTEST051;'
----------------------------------------------------------
grant select on DEPT to test051;
grant select on EMP to test051;
grant select on BONUS to test051;
grant select on SALGRADE to test051;

4.执行拼接好的语句

SQL> grant select on DEPT to test051;
grant select on EMP to test051;
grant select on BONUS to test051;
grant select on SALGRADE to test051;
Grant succeeded.

SQL> 
Grant succeeded.

SQL> 
Grant succeeded.

SQL> 

Grant succeeded.