grant select 遇到的问题,长时间hang住了:
1、SQL> grant select on szgrp.td_m_depart_all to szhrms;
grant select on szgrp.td_m_depart_all to szhrms
ORA-01013: user requested cancel of current operation
2、分析原因:
select * from dba_ddl_locks where name='TD_M_DEPART_ALL';
SESSION_ID | OWNER | NAME | TYPE | MODE_HELD | MODE_REQUESTED |
1613 | SZGRP | TD_M_DEPART_ALL | Table/Procedure/Type | Share | None |
从session、sql视图查询得到sql语句,有一update语句一直在执行,hang住了,从2月9日一直在执行。
找到操作系统进程,kill进程即可赋权。
3、赋权成功
SQL> grant select on szgrp.td_m_depart_all to szhrms;
Grant succeeded