ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

OS : window

Oracle : 11g

접속 방법 : Client -> Server 접근시도

권한이 불충한 이유

------------------------------

grant create session to 유저ID;

grant create session to krmgr;

------------------------------

grant create any table to 유저ID;

grant create any table to krmgr;

------------------------------

grant connect, resource to 유저ID;

grant connect, resource to krmgr ;

grant connect , resource , sysdba  to KRMGR

권한회수를 원하면

REVOKE sysdba ,FROM KRMGR