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.