摘要:
批量修改表权限:sql样例:1 grant references, alter, index on BDP_CBW.TMP_T_TELE_INFO to CBW;2 grant references, alter, index on BDP_CBW.T_PARAM_ENUM to CBW;3 grant references, alter, index on BDP_CBW.T_ORG_INDUSTRY_ATTRIBUTE_8888 to CBW;当然了,BDP_CBW地下还有很多表要写,每个手动编写会很麻烦,直接用一个sql语句生成所有要执行的代码:select 'gran... 阅读全文
摘要:
select * from v$access o where o.OBJECT like 'XXWPF007%' --查找正在运行的对象,获取sidselect a.serial#from v$session a WHERE A.SID=sid --通过sid 获取serial#alter system kill session 'sid,serial#' --eg:alter system kill session '123,3211' 阅读全文