Oracle日常错误

ORA-01045：user system lacks create session privilege; logon denied

原因：该用户没有创建session会话的权限

在Google找到这段的说明：

What does “ORA-01045: user USERNAME lacks CREATE SESSION privilege;

logon denied” mean?

It means that the username and password with which you tried to login are known and accepted by the Oracle server, but that the username doesn’t have permission to create a session. If you think this username should have permission to create sessions send mail to acisdba.

解决办法：

进入sqlplus模式

sqlplus / as sysdba;

使用系统用户登录后，使用如下sql语句给出错用户赋权限

grant create session to UserName;(UserName是登录出错的用户名)

 

-----------------------------
ORA-01031: 权限不足

在 脚本更新时，报错：ORA-01031: 权限不足。
grant connect,resource,dba to  UserName;(UserName是登录出错的用户名)；

赋权DBA之后，还有这个错误。

执行 grant all privileges to UserName;(UserName是登录出错的用户名)；
赋予任何主机访问数据的权限，问题解决