DBMS/Oracle
12c이후부터 lock 모니터링 권한 오류시
itexit
2022. 7. 4. 10:54
반응형
오렌지를 사용하다보면 12C이후부터 lock 모니터링 탭에서 권한이 부족하면 발생
grant select on sys.GV_$instance to system;
grant select on SYS.OBJ$ to system;
grant select on SYS.GV_$LOCK to system;
grant select on SYS.GV_$SESSION to system;
grant select on SYS.GV_$PROCESS to system;
grant select on sys.user$ to system;
grant select on sys.v_$sql to system with grant option;
grant select on SYS.OBJ$ to system;
grant select on SYS.GV_$LOCK to system;
grant select on SYS.GV_$SESSION to system;
grant select on SYS.GV_$PROCESS to system;
grant select on sys.user$ to system;
grant select on sys.v_$sql to system with grant option;