ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string) ORACLE 报错 故障修复 远程处理

文档解释

ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)

Cause: There are several possible causes for this message: First, you will get this message if your username in the second database specified was not granted the CREATE SESSION system privilege. Second, you will get this message if the username specified in the connect string of the database link definition was not granted the CREATE SESSION system privilege.

Action: The action you take depends upon the cause of the message: In the first case, ensure that your username in the secondary database was granted the CREATE SESSION system privilege. In the second case, ensure the username specified in the connect string of the database link definition was granted the CREATE SESSION system privilege in the secondary database.

这是一个Oracle数据库错误。它表明当用户尝试使用某个数据库链接（linkname string）时，该用户没有CREATE SESSION特权。

官方解释

ORA-012345：用户字符串在数据库链接（链接名字符串）中缺少CREATE SESSION特权

常见案例

当用户尝试访问数据库上其他用户账号时，他们可能会遇到此错误。

正常处理方法及步骤

要解决这个错误，您需要：

1.确定要为其分配CREATE SESSION特权的用户；

2.使用GRANT语句来授予特权；

3.重新尝试访问该数据库连接或目标数据库对象。