The SELECT permission was denied on the object ‘Object Name’

This is simple guide for you in Dynamics NAV. Most of the times after restore database you will get

“The SELECT permission was denied on the object ‘Object Name’, database ‘DB Name’, schema ‘dbo'”

error. Object Name and Database name will depend on your database. Mostly bellow errors will get.

The following SQL error was unexpected.
The SELECT permission was denied on the object ‘User Property‘, database ‘MyDatabase’, schema ‘dbo’.

The following SQL error was unexpected.
The SELECT permission was denied on the object ‘Object‘, database ‘MyDatabase’, schema ‘dbo’.

The following SQL error was unexpected.
The SELECT permission was denied on the object ‘Object Metadata’, database ‘MyDatabase’, schema ‘dbo’.

When you search the error on Internet you will get more suggestion including some SQL commons such as

use [2009DB]
go
grant select on [dbo].[Object] to public
go.

but I would reccomond you to check db_owner permission on NT AUTHORITY\NETWORK SERVICE for your restored database. After giving this permission to your database, you will be able to log into RTC.

Your comments and suggestions are highly welcome.