plsql 用户登录时出现ORA-01045: user lacks CREATE SESSION privilege; logon denied

报‘ORA-01045: user lacks CREATE SESSION privilege; logon denied’，原来是创建User时没有给赋上create session权限，

解决办法：grant create session,resource  to  用户名

或在pl/sql developer里，创建user时选择system privileges->create session

转载于:https://blog.51cto.com/dslzc921029/1641637