When I try to connect to my application I received the following error.. “The SELECT permission was denied on the object ‘Home_add’, database ‘myonttv’, schema ‘dbo’”. I did find it was due to missing permission in the database and wish someone could be benefited from this.
What you have to do is to set Database Role membership permissions on the database..
Open SQL Server Management studio
Navigate to the database having issue ..
Click and select general and inside “Database Role membership” section select db_datareader, db_owner options ticked..
The SELECT permission was denied on the object.
