没有合适的资源?快使用搜索试试~ 我知道了~
数据迁移脚本,数据泵导入导出,以及表分析等
需积分: 10 10 下载量 114 浏览量
2016-06-23
14:59:34
上传
评论
收藏 7KB TXT 举报
温馨提示
试读
5页
数据迁移脚本,数据泵导入导出,以及表分析等
资源推荐
资源详情
资源评论
--oracle收回dba权限语句
--revoke dba from username
--username用户没有DBA权限的情况下,需要添加的权限。
grant select on SYS.V_$LOCK to username;
grant select on SYS.V_$LOCKED_OBJECT to username;
grant select on SYS.V_$LOCKS_WITH_COLLISIONS to username;
grant select on SYS.V_$LOCK_ACTIVITY to username;
grant select on SYS.V_$LOCK_ELEMENT to username;
grant select on SYS.V_$LOCK_TYPE to username;
grant select on SYS.V_$OPEN_CURSOR to username;
grant select on SYS.V_$PROCESS to username;
grant select on SYS.V_$PROCESS_MEMORY to username;
grant select on SYS.V_$PROCESS_MEMORY_DETAIL to username;
grant select on SYS.V_$PROCESS_MEMORY_DETAIL_PROG to username;
grant select on SYS.V_$SESSION to username;
grant select on SYS.V_$SESSION_CONNECT_INFO to username;
grant select on SYS.V_$SESSION_CURSOR_CACHE to username;
grant select on SYS.V_$SESSION_EVENT to username;
--grant select on SYS.V_$SESSION_FIX_CONTROL to username;
grant select on SYS.V_$SESSION_LONGOPS to username;
grant select on SYS.V_$SESSION_OBJECT_CACHE to username;
grant select on SYS.V_$SESSION_WAIT to username;
grant select on SYS.V_$SESSION_WAIT_CLASS to username;
grant select on SYS.V_$SESSION_WAIT_HISTORY to username;
grant select on SYS.V_$SESSTAT to username;
grant select on SYS.V_$SORT_SEGMENT to username;
grant select on SYS.V_$SORT_USAGE to username;
grant select on SYS.V_$SQL to username;
grant select on SYS.V_$SQLAREA to username;
--revoke dba from username
--username用户没有DBA权限的情况下,需要添加的权限。
grant select on SYS.V_$LOCK to username;
grant select on SYS.V_$LOCKED_OBJECT to username;
grant select on SYS.V_$LOCKS_WITH_COLLISIONS to username;
grant select on SYS.V_$LOCK_ACTIVITY to username;
grant select on SYS.V_$LOCK_ELEMENT to username;
grant select on SYS.V_$LOCK_TYPE to username;
grant select on SYS.V_$OPEN_CURSOR to username;
grant select on SYS.V_$PROCESS to username;
grant select on SYS.V_$PROCESS_MEMORY to username;
grant select on SYS.V_$PROCESS_MEMORY_DETAIL to username;
grant select on SYS.V_$PROCESS_MEMORY_DETAIL_PROG to username;
grant select on SYS.V_$SESSION to username;
grant select on SYS.V_$SESSION_CONNECT_INFO to username;
grant select on SYS.V_$SESSION_CURSOR_CACHE to username;
grant select on SYS.V_$SESSION_EVENT to username;
--grant select on SYS.V_$SESSION_FIX_CONTROL to username;
grant select on SYS.V_$SESSION_LONGOPS to username;
grant select on SYS.V_$SESSION_OBJECT_CACHE to username;
grant select on SYS.V_$SESSION_WAIT to username;
grant select on SYS.V_$SESSION_WAIT_CLASS to username;
grant select on SYS.V_$SESSION_WAIT_HISTORY to username;
grant select on SYS.V_$SESSTAT to username;
grant select on SYS.V_$SORT_SEGMENT to username;
grant select on SYS.V_$SORT_USAGE to username;
grant select on SYS.V_$SQL to username;
grant select on SYS.V_$SQLAREA to username;
资源评论
烈火138
- 粉丝: 361
- 资源: 6
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功