Help me please.........

jackkie

I cheked to SQL Server and tick "Select , update" already but I cannot posted to Item. Now I feel bad.

The following SQL Server error(s) occured while accessing the Item table:
229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE permission denied on object 'Premium$Item', database 'my-navision',owner 'dbo'.

Please...

kine

jackkie wrote:

I cheked to SQL Server and tick "Select , update" already but I cannot posted to Item.

Where you "checked select and update"? On MS SQL? In Navision? Which rights have user in Navision? PLease, detailed description needed...

tsundboe

I have the same problem. Does anybody know a solutin to this problem??

kine

I am waiting for more info...

Mehdi.Chahed

Hi,

I'm curious to know that "Select , update" check case. I never seen it before... :shock:
Someone can send a screenshot from it!

kine

Jackkie, If you want answer, post more info. There is no information for others to know, what is wrong and what are you doing... :?

DenSter

You should never mess around with any settings in SQL server in SQL server directly other than database wide access control. All user security can be set up in Navision.