Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Operating Systems & Databases (http://www.baanboard.com/baanboard/forumdisplay.php?f=4)
-   -   Errno 0 bdb_errno 2045 (database error 1045) (http://www.baanboard.com/baanboard/showthread.php?t=69351)

JavierElric 10th October 2016 18:24

Errno 0 bdb_errno 2045 (database error 1045)
 
Hi guys, any ideas?
I am trying to find out why we are getting this error message at login

Thank you so much!

Errno 0 bdb_errno 2045 (database error 1045)
FATAL ERROR: Error 2045 (database error 1045) on select
Can not continue in ottstpstdlib (<70>)[sql.exec]

NPRao 11th October 2016 18:08

Problem:
ORA-1045: user lacks CREATE SESSION privilege; log on denied

Solution:
Do not grant create session using role, grant directly to user:

grant create session to myuser;

Refer to -
https://www.techonthenet.com/oracle/errors/ora01045.php
http://support.esri.com/technical-article/000002254

JavierElric 12th October 2016 19:50

Thank you! it worked. :)
 
Quote:

Originally Posted by NPRao (Post 199594)
Problem:
ORA-1045: user lacks CREATE SESSION privilege; log on denied

Solution:
Do not grant create session using role, grant directly to user:

grant create session to myuser;

Refer to -
https://www.techonthenet.com/oracle/errors/ora01045.php
http://support.esri.com/technical-article/000002254

Thank you! it worked. :)

JavierElric 13th October 2016 14:35

thank you, you are a pro!


All times are GMT +2. The time now is 01:28.


vB.Sponsors
©2001-2017 - Baanboard.com - Baanforums.com