mibuso.com

Microsoft Business Solutions online community
It is currently Fri Dec 19, 2014 2:28 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Select Permission Error
PostPosted: Thu Aug 02, 2012 4:39 am 
Offline

Joined: Wed Jan 28, 2009 6: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?


Top
 Profile E-mail  
 
 Post subject: Re: Select Permission Error
PostPosted: Thu Aug 02, 2012 6:56 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Jul 31, 2003 11:00 am
Posts: 640
Location: Nürnberg
Country: Germany (de)
Which "Security Model" arte you using? I recommend "Standard"!

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
 Post subject: Re: Select Permission Error
PostPosted: Thu Aug 02, 2012 7:03 am 
Offline

Joined: Wed Jan 28, 2009 6: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


Top
 Profile E-mail  
 
 Post subject: Re: Select Permission Error
PostPosted: Thu Aug 02, 2012 7:20 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Sep 02, 2008 7:37 am
Posts: 4628
Location: Hyderabad
Country: India (in)
Check in Navision only
File-->database-->Alter
Check under Advanced tab

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Select Permission Error
PostPosted: Sat Aug 04, 2012 3:55 am 
Offline

Joined: Wed Aug 01, 2012 3:26 am
Posts: 14
Country: United States (us)
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.

_________________
MacUxPC
Dynamics-NAV.org


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: