创建用户要给session权限，报错：user lacks CREATE SESSION privilege

GPS平台、网站建设、软件开发、系统运维，找森大网络科技！
https://cnsendnet.taobao.com
来自森大科技官方博客
http://www.cnsendblog.com/index.php/?p=1634

 

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 <user>
或在pl/sql developer里，创建user时选择system privileges->create session