No right to read session table

vanrofi

Hi All,

I think I'm overlooking something, here is the problem :

a user who has super-rights on a SQL 5.0 SP1 database does still get error message : No right to read session table when checking the current sessions via the Database information form (F6 on current sessions).

On this server there are other nav DB running, even with giving the user super rights on these db, same problem.

Can't see the difference with my account, while I can open the sessions form to check on current sessions.


thx for your help // will buy you a beer on the Mibuso-conference next month if your reply helped ;-)

Sog

Is the session table included of your licence?
Is the user on sql dbowner?

vanrofi

Yes, it is included (I can read it, don't I?)

The user has no extra roles on SQL level. I know that when I flag Sysadmin, user will be able to read, but I was in fact wondering that there was a workaround for this.

stryk

Hi!

That's a known bug in NAV 5.0 SP1, you need to install a recent Update to fix this.

Meanwhile you could try to grant the required rights manually in SQL Management Studio:

USE [My_NAV_Database]  -- change db name here
GO
GRANT ALL ON [Session] TO PUBLIC
GO

Does this help?

Best regards,
Jörg

vanrofi

It is solved with that query!

Great! So one beer for you on Mibuso conference...how to recognize me?

M,37,1.90,45,BB and thirsty :-k

stryk

LOL
Unfortunately I cannot participate at the "MIBUSO Conference" so you have two beers (at least)