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

来源:互联网 发布:纪如璟和唐嫣 知乎 编辑:程序博客网 时间:2024/06/06 02:01

又报‘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

0 0
原创粉丝点击