Whenever I remove the admin right from any user, BaaN doesn't allow to login and returns the message "Database not on".


Here all the users are domain users. For security reason we want to remove the admin rights from the users except "BaaN".


If anyone can help me to sort out the issue ....


Rgds......

It sounds like when you are removing the admin rights, the user no longer has read access to the $BSE/lib/db_users file (most likely, to the whole $BSE/lib or even the whole BSE). This file is used to determine the credentials for the user to log onto the database, so if it can't be read, it may look to the client as if the database is not on. I would check the permissions that the non-admin users have in your BSE and adjust as necessary.

Vince

While viewing Event Viewer I am getting the following errors.


Env BaanIV (e:\baan)
Prog ora8_srv file \db\servers\ORACLE_2\oci_shlib.c # 333
Keyword OCI error
Username test type N language 2
Process 0x858
Lasterror 997 (Overlapped I/O operation is in progress.)
Errno 2 (No such file or directory)
bdberrno 0
Message
dbs_errno = 510 Error 510 occurred:
Could not load shared Oracle library
path = F:\oracle\ora92\bin
library = oci.dll
Flushed at \db\servers\ORACLE_2\oci_shlib.c : #350.



Env BaanIV (e:\baan)
Prog ora8_srv file \general\lib\al_1\al_sli.c # 596
Keyword shl
Username test type N language 2
Process 0x858
Lasterror 5 (Access is denied.)
Errno 2 (No such file or directory)
bdberrno 0
Message Load of shared library failed 'oci','-';


Env BaanIV (e:\baan)
Prog ora8_srv file \general\lib\al_1\AL_LDRES.C # 195
Keyword resource
Username test type N language 2
Process 0x858
Lasterror 0
Errno 0
bdberrno 0
Message Unexpected end of line at line 4 in file e:/baan/lib/defaults/db_resource



Even when I login on the server with same user Id it returns the same error.


Rgds
Manoj

Hi there,

seems to me that vinceco252 is right, there is a problem with our permissions.

Lasterror 5 (Access is denied.)


You may want to start the bshell with parameters to debug stuff, for instance:

-dbgfdev : debug file access
-logfile <file> : log stdout/stderr output in <file>

Have a look in your tools manual, keyword "executables", there you can find all parameters described. Assuming that you are using GUI and not ascii, in the GUI configuration menue you can enter these parameters in the "Command:" field

good luck

Norbert

This line concerns me as well:

Message Unexpected end of line at line 4 in file e:/baan/lib/defaults/db_resource

Have you recently edited your db_resource file? There may be incorrect syntax causing the database driver to fail. Maybe try renaming the file to db_resource.old (or something) and see if you can log in after that. That will tell you whether there is a problem with that file.

at witch baan version you get the error..?? i think the rights to company 000 are missing.. at erpln and erpc you musst give the user the "default" role. at baan iv you have to give the customer full acces to company 000