ORA-01045: user lacks CREATE SESSION privilege; logon denied

来源:互联网 发布:央企比民企好 知乎 编辑:程序博客网 时间:2024/06/10 01:30

ORA-01045: user lacks CREATE SESSION privilege; logon denied’,创建User时没有给赋上create session权限,

SOLUTION :sqlplus user/pwd as sysdba 用户登录;

grant create session,resource to <user>

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


原文:http://blog.csdn.net/kingliu_leo/article/details/4276791

0 0