Select Permission Error

transmin09 · **Joined:** Wed Jan 28, 2009 7:29 am **Posts:** 8

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 · **Posted:** Thu Aug 02, 2012 7:56 am

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

transmin09 · **Joined:** Wed Jan 28, 2009 7:29 am **Posts:** 8

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 · **Posted:** Thu Aug 02, 2012 8:20 am

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

macuxpc · **Posted:** Sat Aug 04, 2012 4:55 am

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.

mibuso.com

Select Permission Error

Who is online