Select Permission Error

transmin09

Hi,

We have a user who is setup as windows authentication and has had no issue logging in to NAV using that. We have now created a new company and added him in and synchronised his user but he is getting select permission error as below.

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] the SELECT permission was denied to the object"Object",database "BA Equipment Group',schema.dbo

How can i resolve this?

stryk

Which "Security Model" arte you using? I recommend "Standard"!

transmin09

how can i check whether i am using standard or not? i dont know much about SQL so a step by step reply would be handy

Thanks

mohana_cse06

Check in Navision only
File-->database-->Alter
Check under Advanced tab

macuxpc

transmin09 wrote:

Hi,

We have a user who is setup as windows authentication and has had no issue logging in to NAV using that. We have now created a new company and added him in and synchronised his user but he is getting select permission error as below.

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] the SELECT permission was denied to the object"Object",database "BA Equipment Group',schema.dbo

How can i resolve this?

Check if you have populated the field "Company Name" on the role assignments.

Go to Tools --> Security --> Windows Logins

Select the user and click on "Roles". If the "Company Name" is populated, delete it and try again.