Oracle ora-01045錯誤解決方案

問題：
在用PL/SQL進行登入時，出現：”ora-01045 :user system lacks create session privilege; logon denied”。

原因：沒有許可權
在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.

解決方案：
用sys登入Oracle DB後,下grant create session to UserName;(UserName是登入出錯的使用者名稱)