Dear all

NT4.0, MS-sql7, BaanIV (no sp)

My job sequence is below
1. Make the system login user on NT.
2. Make the Baan user thru the session
3. Make the DB user thru the session
4. Use the session, Link between baan users and database users session (ttdba0110m000)
When I make the new one. suddenly the system had been log outed.
So I tried to log in again , but it makes the message below.
"Fatal error : Error 514 (Security error ; probably no permission) on SELECT blabla~~~

There is no user except 'baan' , but It makes the error 514

if you have any idea of it , please let me know.

Thanks

From the order of events that you picture, the database user is created just fine, but your bshell blows up when you try to link the database user to the baan user.

Obviously you have all the required permissions, or you wouldn't be able to create the user accounts.

Now, I seem to remember that a looooooong time ago, I had this brand new Baan IV installation, that had a similar problem, and we actually had to go into the ../lib/user/u* files and fix the DB - Baan connection manually.

So, my question would be: When you say 'no sp', do you mean that you actually have NO Service Pack installed, or are you just in the blind about what SP is installed?
In the first case, I would suggest updating the configuration first and foremost, then get rid of existing u* files, and try again.

Hope this helps some

Hi Francesco

First, there is no service pack.
I have to use the some customzed module that was developed on no service pack. So I can't install any sp.

And I have ask for someting.
- Can I get the detail explain about "updating the configuration first " on your reply?
- Is the trouble occured on NT?

I will waiting your reply :)

Thank you.

ps : If I can't make the another db-users except "baan", I will try to link the "baan"user(DB user) for another end user(baan user).

I had the same error the other day.
We are using another database.
My error was:
"$BSE/lib/<databasename>/<dbname>_users" had no entry for the user.
I Inserted a row for the user(copying an existing row), and he was able to log in.
I hope this is of use for You (replacing the <.*>'s and the /'s where appropriate.
regards :)

Are you creating a new DB user for every BaaN user?

In case you are, then just try and link the newly created Baan user, with an existing DB user. (i.e. which is already linked to a working Baan user).
If the problem gets solved, then your DB user is not getting the proper permission of the Database.

Dear all.

Thank you for reply.
The cause is the different name of DBs.
All the name of DBs have to same.

In my case, DB name was generated "baandb" automatically.
But the other names, DB Group names and the name of $BSE/lib/db/db_groups file was different with "baandb"
So I changed groups name.
And then, It's working good.:)

Thanks all