Loading

The SELECT permission was denied on the object 'mainmenu',

Jitendra Kumar

The SELECT permission was denied on the object 'mainmenu', database 'demeats', schema 'dbo'.

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews8y ago
Your database admin to give you access for running SELECT statement. If you are the admin, you can do it using mangement studio. The same issue mentioned here, https://stackoverflow.com/questions/19334041/the-select-permission-was-denied-on-the-object-users-database-xxx-schema?answertab=active#tab-top