Monday, January 18, 2010

The SELECT permission was denied on the object 'Build Version', database ', schema 'dbo'.

  • So you were trying to Restore CRM database on another machine?
  • You used the Deployment Manager to Import Organization?
  • You tried to load CRM using the browser but received something you didn't want to see
The SELECT permission was denied on the object 'Build Version', database ', schema 'dbo'.

No wonder you reached this blog post. Read on. This might help:

  • Open SQL Server Management Studio
  • Select the CRM Database you are working with
  • Right-click the BuildVersion table from the CRM Database and click Properties
  • Select Permissions tab on the left pane
  • Click on View Schema Permission on the right pane
  • Click on Add button
  • Click Browse
  • Select CRMReaderRole of type Database Role
  • Click OK twice (Back to Table Properties Window)
  • Check the intersection Select vs. Grant
  • Click OK

You should be good to go.


  1. Fantastic post !!!
    5/5.... exactly what I wanted to know to get my issue fixed.

  2. not working still same error ,my database is sql server 2008 r2

    1. Hi,

      Firstly, make sure you are receiving this specific error which is relative to BuildVersion table in CRM.

      If it's related to any other table, make sure the user has right privileges on that table.

      You might also want to give the user who is accessing CRM the right user mappings.

      - Run "SQL Server Management Studio"

      - In the "Object Explorer" expand the "Security" folder, go to logins

      - Check if the user which you want is exist. If not then,

      - Right click on the "logins" folder and select "new login..."

      - Search for account you want to add & provide required mappings.

      - Navigate to your application's database, expand it & go to security folder

      - Under user folder add new user and search for your user which you've just added and give him the appropriate permisions on your database

      Hope it helps!