Navision SQL - session table does not exist as the required

lzr

I have a problem with the Navision SQL, login and all works fine. But if I add an user without the super role I get the following (I added all+a couple of other roles):

"session table does not exist as the required object name of test.dbo.session in this database"

I haven't done anything with external tools so I don't know where this comes from, the all role should be enough for giving the user login access right?

ara3n

I would do a navision backup. Create a new database and restore the navision back. Create the users and see if you still get the error.

kriki

ara3n wrote:

I would do a navision backup. Create a new database and restore the navision back. Create the users and see if you still get the error.

I think ara3n is right. This is the best way, because the error lets me think something is corrupt in the DB.[/b]

lzr

Yes, I think I have to redo it. Maybe skip restoring "data common to all users" this time.

Thanks!

lzr

Tried it again and even with Cronus it won't work. After adding tabledata 13, 5121 and 2000000009 (Session) it worked. Are they maybe required for SQL option?

ara3n

When you create a blank database on sql Navision automatically creates the required table. I don't know how they are not created.

lzr

I think I forgot to mention I am using sql server 2005 and Navision 4.0 SP1. Maybe there is a bug in SP1?

lzr

Btw I can't find any table named session in my sql database (with sql server management studio).

Just tried to create a new database and checked the tables, both in Navision and SQL and no Session table.

ara3n

the session table in navision is actually a view in sql. It is created through store procedure when the database is created. Look for views.

lzr

yes, you are right. It exists as a view. Strange that it didn't work.