详细操作步骤:
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.